unique records for mailing

[Guest]

I want to pull a mailing list from a table called "Grants"
There can be mulitple records for each "Applicant Name".
I've managed to limit the query to each distinct applicant name as follows:

SELECT DISTINCT Grants.Applicant
FROM Grants;

However, when I add more fields (address, city, state, zip) the duplicates
come back.
Any suggestions?
Thanks,
MSlayter

 

[Guest]

I don't have the answer to your question, but your background may answer my
question. How do you do this select distinct thing?

 

[Van T. Dinh]

It sounds like you have Records with same Applicant but different address
details..

You will have to decide on which addtree details to use.

See also:

http://www.mvps.org/access/queries/qry0020.htm

HTH
Van T. Dinh
MVP (Access)