Grouping records

  • Thread starter Thread starter Cindy
  • Start date Start date
C

Cindy

Is there a way to group duplicate records and only show that record once in a
query or report? My report contains:

Dep. Last, Dep. First, Dep. DOB, Part. Last, Part. First, Part Last Update
(this field is to only pull those records that were changed between
01/01/2008 and 12/31/2008, which it is doing, but it is doing it multiple
times).

Thank you!
 
Sounds like you need a SELECT DISTINCT query in your report recordsource.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".
 
What's a Select Distinct Query?

Dorian said:
Sounds like you need a SELECT DISTINCT query in your report recordsource.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".
 
What's a Select Distinct Query?

You can create a query and view its Properties. If you change the Unique
Values property to YES, the SQL will change from

SELECT field, field...

to

SELECT DISTINCT field, field...

and will remove all duplicate records from the query (it will also make the
query non-updateable).
 
Back
Top