Help with Query returning newest time stamp

[JessM]

I have a comments box on a form that data stamps the comment in my table.
There can be multiple comments for one record. I want to create a query that
only returns the most recent comment for each record. The time field is
called CurrentTime and the comment is called Comment. Any help is greatly
appreicated.

Thanks!

 

[akphidelt]

Alright, what you want to do is go up to the toolbar click on View--> Totals

Then in the query field section you'll see a new line item that says "Total".

Under the TimeStamp section change the name "Group By" to "Last"

Make sure that you understand that Group By only groups similiar values...
so if you show the dates of a record and have Group By selected in the dates
then each record will have as many records as there are dates.

But if you mess around with this you will get the picture.