Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Displaying Data Summary in FORMs

Status
Not open for further replies.

dip757

Programmer
Jun 8, 2001
13
US
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.

 
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).
 
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
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top