I am trying to write a delete query and it is driving me b......s.
I have a table which contains date,address, FAC,pH,TA etc.
I run a query to select the top 5 by date.
I now want to delete the records not in the top 5. But I do not know where to start to write this. I have tried fiddling...