Append Query

[B McGill]

Can someone please tell me how to write an append query to
bring data from one table into another.

tks

 

[Ken Snell]

Help file has some examples.

Can you give us more info about what you want to do? Standard syntax is

INSERT INTO tblName ( Field1, Field2, Field3 )
SELECT [OthertblName].FieldName1, [OthertblName].FieldName2,
[OthertblName].FieldName3
FROM [OthertblName];