Duplicate query

[chris]

I was hoping someone could help me I have been scanning
past posts to no avail.

I have a database that tracks a number of venues, within
each venue there are a number of sites. An order can
cover a number of venues with many sites in each. The
query I currently have gives me a list of each site within
the venue per order. (Therefore each venue appears
multiple times).

I need to run a mail merge from the results and do not
want to contact the same person 6 times for the one
order. Is there a way that I can omit multiple entries
per venue without doing this manually?

Any help would be greatly appreciated.

 

[[MVP] S. Clark]

Use a Group By query against your current query to extract only the unique
values.

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-