append query with dtae and username

's Computer Specifications

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

's Computer Specifications

Please ignore- wrong Group, sorry

"Dan" wrote:

> 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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Append query with username and date	Dan	Microsoft Access Queries	1	23rd Feb 2010 12:49 PM
Append query - Append to table with Autonumber field	Boon	Microsoft Access Queries	2	29th Jun 2009 06:23 PM
Append query to append lots of record with range input	domibud	Microsoft Access Queries	7	9th May 2008 02:26 AM
Append Query in VBA - to append VBA variable values to Access tabl	=?Utf-8?B?QWdlbnQgRGFnbmFtaXQ=?=	Microsoft Access VBA Modules	4	1st Nov 2006 04:25 PM
Link CSV file created query append query to append data	=?Utf-8?B?ZXNwYXJ6YW9uZQ==?=	Microsoft Access Queries	2	5th Jul 2005 04:49 PM