Help getting the most recent value

[murry]

This has been posted many times on here before, and the page (http://www.baldyweb.com/LastValue.htm) is always given as the solution. I want to do what that page is describing, but I'm very new to Access and I don't understand the page is saying. I am tracking thermometer calibration and their location when they are in service, and want to be able to find the current location. Could someone please explain step by step where the information goes, and what each value means (i.e VehicleMiles.DorDate, AS MaxDate, and VehicleMiles.CarNum). I'm not sure what are access terms and what the code is using from the theoretical table. Thanks in advance.

[June7]

The example shows two query statements. Use query designer to build queries. View the statements in SQL view.

VehicleMiles is table name.

qryMaxDates is name of the first query.

DorDate and CarNum are fields in table.

MaxDate is an alias name existing only in the query.

Max() is an aggregate function. Refer to Access Help for guidance on aggregate (Totals) queries.

All the uppercase words are SQL terms.

* is a wildcard.

Don't know your data so can't say what substitutions you should do.

[murry]

Thank you so much. Just knowing to go to SQL view makes it make since. Thanks.