How to make a "Last Updated Date" Automatically? 1

[Cero21]

First off I'm a beginner Access user but I'll try to explain what I want to do as best as I can.

I am creating a inventory database where each sub unit (number based, 741 744 and 748) can update a main table with what inventory they have. This is done through a form where each unit is restricted to their own equipment by locking their unit number in the form.

Queries are used to view the equipment held by each unit by filtering by unit number.

Reports are then made from each query to get a report of each unit.

The main table alone is made into a report that displays all the equipment from all the units combined.

What I want to do is have access somehow timestamp the last update made by each sub unit. Then I want to place these timestamps into the full report so that I will know when the sub united updated their inventories. Is this possible? And if so, how do I do it?

Thanks for your time.

 

[GingerR]

try DMax()

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html

 

[Cero21]

Awesome. DMax() worked like a glove. Thanks!

(now I just need to figure out my other problems...)