SQL code

[Warren]

could anyone help me

I am working with access 2000
I am trying to append data using SQL code to a table when I close a report.
The report gets some data from a different table through a query, and data
from the user. Any ideas would help


Thanks
Warren

 

[Guest]

cant you just say 'INSERT INTO tablename (field1, field2, field3)
VALUES (value1, value2, value3)'

HTH

there is an append query or append values wizard in XP and 2003.