My query is creating duplicates

[Guest]

Okay, I'm using Access 2003, I've run a query based on a table where I
maintain standard data (Scope Changes) and a data table (Scope Change Data) I
am using for my subforms and subreports. The query is perfect for one
report. For the second report I needed to create a second query, using the
data from the first query, and adding information from my jobsite table. This
is where the problem comes in. The only common factor between the Scope
Change Query and the Jobsite Table is the Project #, once I join the two my
new query gives me duplicates of every entry. I've tried doing this with the
three tables instead of the query and the table and I get the same results.
Obviously I'm doing something wrong but how do I get my query to only give me
one entry for each of my unique items?

 

[Guest]

hi,

I am unsure of your syntax, but first, you have to make sure that you have
one of each scope in the main table. Then you can join that to the details
table to get details for each unique scope in a query. So make sure your
subquery, or saved query retrieves one of each scope. The you can use this
stored query as the source for your main query. You may also want to use a
LEFT JOIN also.

hope this helps,
geebee

 

[Regan via AccessMonster.com]

i think you have to have 'SELECT DISTINCT' at start of query