ID Charge# Resource 7/13/2008 7/20/2008
7/27/2008 8/3/2008
1 V/0153.01 .01.01.01 VSY4 35 32 16 19.75
2 V/0153.01 .01.01.01 VSY4 1 3 2 4
3 V/0153.01 .01.01.01 VSY4 12 4 1 3
4 V/0153.01 .01.01.01 VCEX 54 112 4 141
5 V/0153.01 .01.01.01 VME3 44 78 4 5
I have a table that i ex****ted out of Microsoft project that has dates
by week for 3 years (~160 date fields).
When the data is in this format it becomes very difficult to do
anything in access as far as date filters or parameters. Is there a
way to transpose the data for all 160 date fields to look like the
following.
V/0153.01 .01.01.01 VSY4 7/13/08 35
V/0153.01 .01.01.01 VSY4 7/20/08
32
V/0153.01 .01.01.01 VSY4 7/27/08
16
etc...
Is there a good way to do this? I need to be able to compare a weekly
budget vs a weekly actual.
thanks,
KO
