SQL code

  • Thread starter Thread starter Warren
  • Start date Start date
W

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
 
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.
 
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

VBA - retrieve data on last create named range from previous inserted named range 0
Example Of VBA SQL Statement 0
Access stripping decimal places in query 1
Access Print Files from Query Results 0
Call stored procedure in SSMS from Access 2016 doesn't work. 0
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Slow response from MS access report 4
MS word Find and Replace using Regex - Help required 0

Back
Top