Jumat, 22 November 2013

RE: [MS_AccessPros] Stumped....

 

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 (4)
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar