Bryan
When you need our help for a query you have to post the SQL so we can analyze it. Open your query in design view and then switch to SQL view. That will give you the SQL statement. Post it back here. It’s tough to read minds over the internet...at least for me.
Regards,
Bill Mosca,
Founder, MS_Access_Professionals
That'll do IT http://thatlldoit.com
MS Access MVP
https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-64270730881E
My Nothing-to-do-with Access blog
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Bryan
Sent: Thursday, November 21, 2013 2: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 (2) |
Tidak ada komentar:
Posting Komentar