I'm fairly new to MS Access, so I thought I might get some assistance here. (Background) I have a database (which has been split using the database splitter) with two tables. Table 1, is linked to an excel file which is updated nightly. Table 2 was created by importing the first table. Column 1 in both tables is indexed (no dups), and primary. Table 2 is linked to the back end, and is used to store forms entries, and print reports. I am using an append query to add the new nightly updates from table1 into table2, this seems to work well, as each time the query is run, it does in fact add the new rows created since the last query run. (My problem) One of the common columns on both tables is a quantity field (number, not indexed). I need to update this column with the most recent quantities from table 1 during the daily import. Is there a way to use the append query to overwrite the quantities in table 2, while adding the new rows, or do I need to create a different query? Basically what I need to do with each import is, add the new rows to table2, and update the quantities in table2. Thanks.
Which Query To Use?
- Thread starter davec69
- Start date
Similar threads
