Windows 7 MS Access 2007 get most recent date

[ka3pmw]

I have a need to get the most recent date from one record and put it in another record. The tables are linked. I don't want to run a query every time the date is needed. All I have been able to find requires a query. Is it possible to do this without running a query every time?

 

[arnelgp]

you may want to try the Max() function in your query.

 

[ka3pmw]

I don't want to run a query every time I want that info. Can I make it part of a table?