How to update Rows

S

subbu

Hi,
I am using appendquery to insert rows to the table.My
requirement is to update only the rows that were
inserted.How to track the new rows only

regds
subbu
 
G

GL

You could set up a yes/no field in the table and have the
append query set it to Yes. Then go back and only update
the records that have that field set to yes. Hope this
helps.
GL
 

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

How to update the table 1
How to find out the last inserted row in Access 2
Add 2 rows at 1st time 12
How to give group by in the select query 2
Error while inserting null data in Append Query 1
DateExpression 3
How to merge two separate append queries 4
How to get statistics 2

Top