append query with dtae and username

D

Dan

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Append Crosstab Query to Existing Table 0
Append query with username and date 1
Mail Merge file containing a Word Table 0
Creating a Search using a combo box and then creating a report. 4
Some mail merge fields not pulling into document 2
sqlite-odbc write conflict 2
Display bug in Word: tables disappearing on copy and paste of text with bullet points into table 2
Append Query 7

Top