Displaying Data Summary in FORMs

[dip757]

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.

 

[dip757]

Sorry the spacing got deleted when I posted. Jane's data for A and B code .... 1,123, and 1,120 should line up below FW20 (column).

 

[PHV]

As a starting point you may consider a CrossTab query or a PivotTable.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[dip757]

I tried the cross tab .....

but in the form, i cannot get it to line up like.

FW19 FW20 FW21 FW 22 .........
John D
A 1,000
B 500


I get

FW19 FW20 FW21 FW 22 .........
John D A 1,000
John D B 500