Forum Discussion
Troubleshooting Queries in Access
Hi All, I am trying to run a query in an Access database, the query is expected to populate an existing table with new data, however it is not running as expected. As per the set-up process, 1. ...
An append query will add data to an existing table, whether empty still or already containing data. If you want it to only contain the new records you would have to run a delete records query right before running the append query. But, as George_Hepworth says, further help requires that you show the query.