Microsoft Access hates me - repeating tables

[missalissa]

I am working at a University that needs to send out massive mailings. To do this I need to pull records from an ODBC database into Access, create a query that searches multiple tables for specific criteria, and the answer to that query is my mailing list. This is where I get into
My problem is repeating tables, and I cannot fullly understand or overcome them. After I run the query, I get tons of duplicate records.
Everyone has a unique number, and I have tried to create relationships between tables connecting by that number, and have failed. I have selected the "Unique Records" option, and tanked. I have tried Totals>first, no luck. I need help badly.
My question is this: how can I display the people that match the criteria I need, but only one record per person.


Thanking you in advance, A-liss

 

[PHV]

Instead of SELECT DISTINCTROW have you tried SELECT DISTINCT ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[missalissa]

That did not work.

 

[PHV]

So, any chance you could post the sql code, some input examples and expected result ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[willir]

I get tons of duplicate records

Are these duplicates from siblings or the same person?

You can create a unique index on name + other field, example name + phone nunber - first record gets writted, and others will not.

Richard

 

[GregTheGeek]

Double-check your use of joins. If you don't join correctly, you can multiply records.

Hope this helps!

GTG