Using Max() to show the most recent date

[LoriD]

I have read several postings on other sites, but the explanations are not basic enough for me. Can someone walk me through how to create a MAX expression in a query?
I have a table to track maintenance records on each piece of equipment we own. Each piece of equipment will have many records, and I want (ultimately) to be able to run a report showing all equipment due for, a P/M, for example.
So I m trying to create a query that shows all equipment that have had a P/M (this much I ve been able to do), but now I want it to show me only the most recent record for each piece of equipment.
Can anyone help?

[tagger418]

-Create a new query in design view
-Add the table that you would like to query
-Close the <b>Add Table</b> dialog box
-Add the equipment and date or time field to the query
-Select <b>View>Totals</b>
-Set the Time or Date field to Group By <b>Max</b>