Bryan
If the two tables are not related don't put them in the same query. If you do you will get a Cartesian result. Say you have 10 records in table1 and 3 in table2. You will get a total of 30 records.
If you need both tables for the report use a main report and put the smaller of the two sets in a sub report in the main report's report footer
---In MS_Access_Professionals@yahoogroups.com, <bmorris.gm@gmail.com> wrote:
Ok – I found the cause….
The Budget table actually had a query had 2 entries that matched…that caused me to get duplicate entries in the query I was then running…
Uggg – so much fun trying to figure out what the original designer was thinking….
Thank you for your advice on what to paste next time I have a query question.
Maybe it's not the best design, but the query I am revising has the master db table and a query of a different table (different table is budget numbers and not related to the master table) – so the report uses the results of the master db query for the year with two fields that contain budget numbers for the project types.
(I did not design the db – only working within the confines of the existing structure)
B
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Bryan
Sent: Thursday, November 21, 2013 5:53 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Stumped....
Ok – this is probability an easy answer for people, but it's stumped me….
I have a query that is returning the entry twice…… (yep the same record number is repeated)
The query has 2 tables, Master and Budget
Fields in the query include majority of the Master fields and 2 of the Budget fields (the 2 tables are not linked)
When the first field (FY) has valid data ("14") searched for, 6 records are returned…should only be 3 (other 3 are duplicates)
What am I not "seeing"???
Thanks,
B
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (5) |
Tidak ada komentar:
Posting Komentar