The first answer is the solution. (WITH previousweek...) Terrific. The updates do go into the storeproducts table which holds the list of products for each store in each group of stores (A group consists of all stores in a particular state). (A callsheet is prepared each week for each group of stores. Someone calls each store for the quantity of product they want that week and then they are delivered). So GroupID in the sample really referred to the set call sheets for all the stores in one area for a particular week. GroupID = 1 is the set of callsheets for the particular stores for the first Monday. Group 2 is the callsheet forthe set of the same stores and same products for the second Monday. So each week the person making the calls wants to see what the store ordered last week for each product. The storeproduct table links to the "StoreList" (in the sample) and from there can link to a Stores Table to get the real store name. The productID in the storeproducts table links to a product table where the product descriptions, etc. can be gotten. A select query creates the grid which is the call sheet.

I have attached a sample callsheet (it has 730 products actually). This shows the finished product and shows how the results of the query fit in. The first column, quantity, is what they enter each week and next to it is the previous quantity from this query. There is a good reason why the storeID is not in the Storeproducts table, but it is not necessary to know.

I need to put this into the actual table names and run to make sure it will work with all the other things added. I can also flesh out the sample tables to show the store, product information. I realize that just having ID's in the sample is not very helpful but I did not want to add to the complexity -- though I think it would have made it simpler had I done so. So I will add the additional fields to the three tables.

Let me know if there is other information to make it clearer. I am hoping this could function as a good example though it has to be more clearly explained. As I said, I found samples of updating to the same table and updating to a table where a join is needed to one or more other tables, but I did not see the two solutions in one query and I could not figure how to do that. This is a great lesson. Thank you very much for the tips on describing the problem and the solution itself.