A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Copying new records



 
 
Thread Tools Display Modes
  #1  
Old June 25th, 2004, 04:02 PM
John
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 12:13 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.