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!