hi
i have a table with rows of data As below (Reaseon Delay can only be A, B, C, or D)
Order# CustomerName Price FiscalWeek ReasonDelay
1 John D. 1,000 19 A
1 John D. 500 19 B
1 John D. 1,500 19 C
1 Jane D. 1,123 20 A
1 Jane D. 1,120 20 B
1 Jane D. 1,100 22 B
I would like to create a form that shows data as shown below:
FW19 FW20 FW21 FW 22 .........
John D
A 1,000
B 500
C 1,500
Jane D
A 1,123
B 1,120 1,100
Please help me think thru how to get this formatted as per above.
I would also like to get summary for each A, B, C, D.
Thank you.
i have a table with rows of data As below (Reaseon Delay can only be A, B, C, or D)
Order# CustomerName Price FiscalWeek ReasonDelay
1 John D. 1,000 19 A
1 John D. 500 19 B
1 John D. 1,500 19 C
1 Jane D. 1,123 20 A
1 Jane D. 1,120 20 B
1 Jane D. 1,100 22 B
I would like to create a form that shows data as shown below:
FW19 FW20 FW21 FW 22 .........
John D
A 1,000
B 500
C 1,500
Jane D
A 1,123
B 1,120 1,100
Please help me think thru how to get this formatted as per above.
I would also like to get summary for each A, B, C, D.
Thank you.