Hello
I am using Access 2003.
I have a database that is updated monthly with new data. But because there could have been corrections to data from previous months, I want to overwrite records in the current database if they've been updated in the new data and leave others as is (so not entirely wiping out the table first).
Ideally I want to create a button to import "new" data to a temporary table and then run an update query with the new database to the old.
The problem is that I've searched for awhile on how to use update queries and can't figure it out. Both tables are an exact mirror of each other with 27 columns. The unique identifier is a combination of two fields: chartnumber and account number.
Can anyone please point me in the right direction or even tell me if this is the right approach? Thanks very much.
I am using Access 2003.
I have a database that is updated monthly with new data. But because there could have been corrections to data from previous months, I want to overwrite records in the current database if they've been updated in the new data and leave others as is (so not entirely wiping out the table first).
Ideally I want to create a button to import "new" data to a temporary table and then run an update query with the new database to the old.
The problem is that I've searched for awhile on how to use update queries and can't figure it out. Both tables are an exact mirror of each other with 27 columns. The unique identifier is a combination of two fields: chartnumber and account number.
Can anyone please point me in the right direction or even tell me if this is the right approach? Thanks very much.
