How to get the latest date?

C

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
 
J

Jim Ory

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top