access query to find unique values

[tonyrulesyall]

I am using Access XP. I would like to identify unique values in
tables with a query.

This is how the raw data looks:
Customer Date
A 10/1/2008
A 10/1/2008
A 10/2/2008

This is what I would like the output to look like:
Customer Date
A 10/1/2008
A 10/2/2008

 

[nata]

try this:
SELECT Table1.Customer, First(Table1.Date) AS Date
FROM Table1
GROUP BY Table1.Customer, Table1.Date;

 

[John Spencer]

SQL would look like the following. The DISTINCT key word "rolls up" records
that have identical fields displayed.

SELECT DISTINCT Customer, [Date]
FROM [Your Table]

How to do this in query design view instead of in SQL view:

In query design view, click on a blank area in the top of section (next to a
table NOT ON a table). In the Query Properties dialog, change Unique Values
to Yes.

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