I am wondering if there is an update query to update data after a certain row. I have 405020 rows and I know that anything row 366297 and prior is to be True and anything after false. Is there a query to do this?
Competent Performer
Windows XP 
Access 2007
I am wondering if there is an update query to update data after a certain row. I have 405020 rows and I know that anything row 366297 and prior is to be True and anything after false. Is there a query to do this?
VIP
Windows 7 64bit Access 2010 32bit
Need filter criteria to exclude the records - date, ID, something.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
How do I insure that my Update Query will only update the current record?
One Update Query to Update several fields simultaneously
Having trouble using update query to update fields within the same field using logic.
Is an update query with user input of data to update TO, possible?
Posting Permissions
Reply With Quote