I have a query with 4 fields in it for usage of a device.
Location#


Location name
Serial Number
TripDate

What I am looking is to see if the device was used anytime last week. I have Group by selected for each for each field except the expression at the end that queries for last week records.

Year([TripDate])* 53 + DatePart("ww", [TripDate]) = Year(Date())* 53 + DatePart("ww", Date()) - 1


The problem is that because the date is not the same, I am getting duplicates records for the devices instead of it combining them. I also can't change the TripDate to anything other then Group By or the expression will not work. I have show unchecked but is not working and I know I had this working before. Basically I just want unique records.