Im sure this is easy for someone, but SQL not my thing and been struggling for too long to get the syntax right to get this to work.
Table: tblDutyList
Fields:
DutyID (Key)
DutyStation
DutyDate
Table collects multiple entries for all Stations, never more than one on a given date.
I need a query to give me the most recent date from each station.
I can get DISTINCT Stations, and I can sort by date - but cant get those things working together.
Thanks.