Delete Query base on Min date value in field

[ui7598h]

My field names in my table are PersNo, WS rule, Logdate, Start, Day assignment, TID


I am attempting to build a query where entire records are deleted where the Day assignment field contains "Assignment to previous day", and the Log date field is the MIN date of all the records. See below. I need to have the record within the blue box removed. There are several of these records in the table.



Please help!!!

Steve

[Rawb]

Generally, unless you're using a lookup Table, you shouldn't need (or want?) to delete Records from a database. I'd recommend adding a "Yes/No" Column to the Table. Then you can alter your Queries to only return Records where that value is True.

That said...

DELETE 
FROM MyTable 
WHERE [Day assignment]="Assignment to previous day (set automatically)" 
  AND [LogDate]=(SELECT MIN(t_1.[LogDate]) As LogDateMin FROM MyTable AS t_1)

The above Query should work if you change MyTable to the actual name of your Table.