Query based on last date 1

[dulla]

how do i run a query to pull up the records that are affiliated with the last date of entry. i have a field called 'process date' to capture date, but i need to bring up the records that are the latest so i can display their current status. i don't want to do it by lastrecord because some records may be out of sequence and the only sequential identifier would be date. any ideas?? thanks.

ameen

 

[mikevh]

SELECT *
FROM YOURTABLE
WHERE [PROCESS DATE]=(SELECT MAX([PROCESS DATE]) FROM YOURTABLE);

where "YOURTABLE" is the name of your table.

 

[JasonPurdueEE]

thanks mikevh, you're post helped me too!

______________________________
Sleep is a poor substitute for coffee.