showing only unique records

N

namsilat

I have two databases linked, one keeps basic client information (name,
DOB, address, etc.), the other keeps track of client's visit date and
purchases. I want to display a list of clients that made purchases
within a given date range, regardless of number of purchases made.

With the simple query view, somehow I end up displaying one row for
each client's purchase(s), i.e. if the client made 10 purchases in the
date range, then I see 10 entries displayed for such, when I only want
to see that client's name shown once. Is there a quick way to avoid
displaying the duplication?
 
A

Arvin Meyer [MVP]

If you are looking for the latest record use a "Totals" query (the Sigma
button) and change Group By to Max in the date field.
 
J

John Spencer

Don't display the date field or any other non-unique information from the
purchases table
- uncheck show field in the query grid
- enter your date criteria
Set the Unique Values property of the query to Yes
To do this:
--Right Click on the top section of the query (not on a table)
--Select View Properties from the menu

--
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
Top