How to populate a table with prior week's data

[olive]

Hi everyone!



I'm a complete newbie with Access, as I typically only ever have to use Excel for work.

Unfortunately, I'm doing something that requires me to stitch together a lot of rows.

I've managed to figure out how to get my access table to appear as follows:

Date	Department	Category	Subcategory	Sales	SalesQTY
1/1/2018	Grocery	Fruits	Apple	$0.25	1.00
1/8/2018	Grocery	Fruits	Apple	$0.50	2.00
1/15/2018	Grocery	Fruits	Apple	$0.75	3.00

What I don't know, is how to populate my table with the prior week's information.

Date	Department	Category	Subcategory	Sales	QTY	Prior Week1	Prior Week2
1/1/2018	Grocery	Fruits	Apple	$0.25	1.00
1/8/2018	Grocery	Fruits	Apple	$0.50	2.00
1/15/2018	Grocery	Fruits	Apple	$0.75	3.00	2.00	1.00

Any guidance is very much appreciated!

[isladogs]

The simple answer is, you wouldn't do that as you would be saving the same data repeatedly.
The idea is that data should only be stored once

So stick with the first table & if you need the additional columns, you do that using queries