Append Query to Insert Table Name

  • Thread starter Thread starter Jason Rhymes
  • Start date Start date
J

Jason Rhymes

Is there a way to have a Append query insert the table name it came from as
one of the fields? And maybe also a date stamp?
 
Yes,

INSERT INTO Table2 ( field1, field2, field3 )
SELECT "Table1" AS Expr1, Date() AS Expr2, Table1.field3
FROM Table1;
 
That works. I had to take Table1.field3 out because it came up w/ a dialog
box to type info for it. And I changed Date to Now to get a more accurate
reading. Thanks
 
You must log in or register to reply here.

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

AutoNumber Field Not Populating with Append Query 2
Append Query Issue 0
Schedule Auto run Query on append table 0
Access 2007 Append Query – Issue with automatically inserted brack 3
Add Table Name as Field in an Append Query 1
Appendding to/from Upsize_ts (time stamp) field 3
Append if Not Exist 4
Append Query 2

Back
Top