Update Query / last update system date?

B

Brook

Good Day All,

I have a qryupdateinventory that I update on close of my invoice form.
I have a field within my tblinventory called "LastUpdateOn". What I would
like to do is when the qryupdateinventory is run on close of the frminvoice,
the current system date is updated in my tblinventory field "lastupdateon".

Does anyone have any 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 "LastUpdateOn" 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.
For example, post the SQL view of the update query, and let us know
whether you are using an OpenQuery method, or a RunSQL method, or an
Execute method, or....
 
B

Brook

Thanks for the prompt response.

I used the Now() function and that is exactly what I was looking for.

Thanks agian..

Brook
 
Top