update query ... add last update system date?

B

Brook

good Day,

I have a qryupdateinventory, that updates tblinventory from
tblinventorydetails. I would like to add a field for "last update performed
on". I guess this I would use a last updat performed on would be a system
date, but I am unsure how to add it to the update query?

any ideas, suggestions?

Thanks,

Brook
 
S

Steve Schapel

Brook,

Use the Date() function, or the Now() function if you wish to include
the time as well as the date. Just include this in your update query to
apply to the "last update performed on" field. Since there are a number
of approaches to update queries, you will need to let us know details of
which approach you are taking, if you need more explicit help with this.
 
Top