display records only with most recent date

[bogglebeats]

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

 

[ianacole]

Another option, I stumbled across in my efforts, as I am trying to report the last date a dial-up access modem was tested, across 30 routers. In my form, I have the primary form capturing the router information, and then a subform (datasheet) to document pass/fail statuses for each week tested, sequentially. My report is based on a query of the two linked tables.

In my query, I sort the tested date field in descending order. While I have the column selected, select 5 from the "Top Values" droplist on the toolbar, highlight the "5," type "1," hit enter, and check the query.

I now display the last date that a router was tested. I hope this is what you are wanting to accomplish, otherwise, I apologize for wasting the space

GL

Ian