Weekly incremental data - reporting per week over the supply chain

[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
2 1-jan 6-jan 12-jan | delivered
3 8-jan 12-jan | on transport
4 14-jan | produced

but no I want to create a matrix where I can show the data (products
moving through the supply chain). In week 1 only 2 rows where
applicable and in production, etc

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

 

[Guest]

When importing the file, you need to add a date/time field that contains the
date of the data. Then you can do a crosstab query that will provide the data
as you want.

 

[derek wilkie]

hello everyone, new to computer world, how do i erase data from a cd-rw.
thank you.