Query No Duplicates

[Brent113]

I have a query that is set up to return who did each event the happened. One person can do many events, so the query returns the person multiple times, as they are tied to each event. How can I modify the query to return the person if they are not already listed in the query (no duplicates)?

Thanks in advance,

Brent Scrivner

 

[Brent113]

oh man, sorry. It's in MS Access.
brent

 

[SkipVought]

Hi,
In the SQL View add DISTINCT

Select Distinct fieldname...
From YourTable

Hope this helps

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[Brent113]

I have that in there, but it doesn't make any difference. I have also tried DISTINCTROW to no avail

 

[xlbo]

aahhh - think this is a join issue. If you are using the design grid, you need to set the join between the 2 tables (I assume there are at least 2 tables). Lets say table1 has employees and table2 has events
Double click on the link line between the 2 tables
You need to select the option on join to bring ALL records from table 1 and only those from table 2 that match.
Apologies to anyone that really knows access - I'm sure this has a proper name but I dunno what it is

Rgds, Geoff
Quantum materiae materietur marmota monax si marmota monax materiam possit materiari?
Want the best answers to your questions ? faq222-2244

 

[Brent113]

I found an answer. Thanks to all for the ideas. It involves showing totals, then group by. Thanks again, Brent