I'm trying to build a single table query which displays the last date that a specific event (target change) was performed, with some details. The basic query I have looks like this:
SELECT TOP 1 chamberPosition AS [Position], targetID, date
FROM TargetChange_tbl
WHERE chamberPosition=1
GROUP BY...