Hopefully Simple Append Query

[brendanolear]

I have a weekly table that contains two columns - Sales ID - Units Sold.

The current table is my master table, I shall create a new table each rolling week.

What I would like to be able to do is identify if the Sales ID on any future weeks is on the current table, and add to the overall total units sold on an ongoing basis.

The rolling updated weekly table would then be my master table for the following week etc.

Do I need to create an "Append Table" query to allow this, and what would be the formula structure to allow ongoing capture?

 

[Phildaburn]

I don't think I fully comprehend your db structure here. By the current table being a "master" table, are you saying that it contains all past values of Sales ID? But then your weekly table becomes your master table the following week? Can you provide something more concrete? Some examples would be helpful as well.

Thanks... Phil...

 

[Norie]

Brendan

That's sounds more like an update query to add the values from the weekly table to the master table based on ID.

Or have I misunderstood?

If all you want to do is add the weekly records to the master table, that would probably be a straightforward append query.