Display Only First Record of Repeating Records?

N

Neil Cash

I have a table in which two fields are repeated (Job Number and Service).
I'd like to create a query that only displays the first row of the repeated
records, so that the job number and service combination will be unique
(ideally it would display it as if a job can have multiple services, but
never have the same service twice). Any ideas? Thanks in advance.
 
D

David Seeto via AccessMonster.com

You can do this by either creating a GROUP BY with those fields as the
total, or you can change the SQL from SELECT DISINCTROW to SELECT DISTINCT -
both will eliminate the duplicates.
 
Top