Unique Values (A2K SR1)

[TomGoodwin]

I have a select query based on tblRental that selects records based on a date. It is possible to
return multiple records for the same [RoomNumber]. I want to be able to exclude all but the first
record for each [RoomNumber].

I was trying to use SELECT DISTINCT tblRental.RoomNumber FROM tbl.rental

The existing SQL begins SELECT DISTINCT tblRental.OrderID, tblRental.RoomNumber, etc

Can you add some type of

[HansV]

Make the query into a Totals query. The Totals line will read Group By for all fields by default. Leave it that way for RoomNumber, but set it to First for the other fields.