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