How to get the latest date?

[Capt'n]

Hi,
I am using Access 2000. I have two table: Assets and Maintenance
Relationship in one to many from the asset table to the maintenace
table. The maintenance table is Index by AssetID asc and MaintDate
Desc.

I need to show the latest maintenace date for each asset as the user
scrolls through the rows.

The maintenance form is a subform of the Asset form.


My question is how to I code the LastMaintDate field to get the latest
date from the Maintenance table for this asset?

Thanks,

Capt'n

 

[Guest]

If you base your 'maintenance' subform on a query you can sort ascending or
descending dates. When the form opens, it should show the latest date first,
assuming you've made the sort order for the date field descending.