Append query with username and date

I am using an append query to add a new line to my table - one of the field
in this table is "Update_Date" and one is "Updated_By".
How via this query I can populated those two fields with the current
date&Time and current username of the user .
Many thanks,
Dan

In query design view, type this into a fresh column in the Field row:
Now()
Below that indicate the field you want this value assigned to.

Do a similar thing with:
CurrentUser()
for the other field.

Note that CurrentUser() always returns "Admin" if the database is unsecured.
If you wanted the Windows user, use the GetNetworkUserName() function from
he
http://allenbrowne.com/ser-53code.ht...etworkUserName

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.


"Dan" wrote in message
...
I am using an append query to add a new line to my table - one of the
field
in this table is "Update_Date" and one is "Updated_By".
How via this query I can populated those two fields with the current
date&Time and current username of the user .
Many thanks,
Dan