If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Copying new records
Hi
I need to copy new records from an access table which can potentially have records added to it all the time by users. I figure I can add a flag for records that have been copied already that can be set after copy. The problem is that in the time that I copy all new records using 'select * from ... where not flag' and coming back to update flags for all records not already flagged, new records could have been entered by the users which may also get flagged as copied with 'update ... set flag=true where not flag'. How can I differentiate between the records that are copied and still not flagged and the records that are new and have not been copied. Thanks Regards |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to Manipulate the group and sorting in a report? | Jorge Novoa | Using Forms | 2 | June 9th, 2004 01:12 AM |
Seperating duplicating records | Michael J. Strickland | General Discussion | 0 | June 4th, 2004 06:56 PM |
Top Records | Gabby | New Users | 1 | May 31st, 2004 11:23 PM |
Printing only if records greater than one | Al Westerlund | Setting Up & Running Reports | 1 | May 21st, 2004 07:46 PM |
Number of Records shown from Filter Mode | Tien Mai | Worksheet Functions | 1 | April 26th, 2004 10:06 PM |