I need to update records in a table from an identical table from a laptop. How can I append some records to the table (if there are any) and update records which have changed slightly, ie the completed field becomes true.
Thanks for any help

Try importing from your laptop. Then create a query joining the existing table and the imported table using an equal join. Then set the query property to unique values only. Those would be the records to UPDATE.

Do a find unmatched query (wizard available) to APPEND.

Good luck!

[This message has been edited by jwindon (edited 01-20-2002).]

Look up this article in the knowledge base:

Q127977 - ACC Updating and Appending Records in One Update Query