S
Seansan
Hi,
I am having trouble understanding if MS ACCESS supports reporting on a
weekly basis, based on data that is delivered in a incremental file
(updated weekly) where data travels through status changes based on
date fields that are populated. I will give an example.
FILE1: WEEK 3 - current status report (date 15-jan)
rec_id | prod_date | trans_date | deliv_date |
calculated status
1 1-jan 4-jan 6-
jan | delivered
1 1-jan 6-jan 12-
jan | delivered
1 8-jan 12-
jan | on transport
1 14-
jan |
produced
but no I want to create a matrix where I can show the data (products
moving through the supply chain).
REPORT
wk1 (2-jan) wk2 (9-jan) wk3 (16-jan)
produced 2 1 1
on transport 0 1 1
delivered 0 1
2
every week I receive a new FILE1 - I want to import this file and then
run REPORT. So for example when receiving the data in WEEK 4 - the 4th
colum is added in the report
How can this be done ????
kind regards, Seansan
I am having trouble understanding if MS ACCESS supports reporting on a
weekly basis, based on data that is delivered in a incremental file
(updated weekly) where data travels through status changes based on
date fields that are populated. I will give an example.
FILE1: WEEK 3 - current status report (date 15-jan)
rec_id | prod_date | trans_date | deliv_date |
calculated status
1 1-jan 4-jan 6-
jan | delivered
1 1-jan 6-jan 12-
jan | delivered
1 8-jan 12-
jan | on transport
1 14-
jan |
produced
but no I want to create a matrix where I can show the data (products
moving through the supply chain).
REPORT
wk1 (2-jan) wk2 (9-jan) wk3 (16-jan)
produced 2 1 1
on transport 0 1 1
delivered 0 1
2
every week I receive a new FILE1 - I want to import this file and then
run REPORT. So for example when receiving the data in WEEK 4 - the 4th
colum is added in the report
How can this be done ????
kind regards, Seansan