Crosstab Query with more than one column header

[maximrose]

Hi,

I need help with crosstab query. My rowheadings are Paydate, StudentName, and PayID, my value is amount and my column is PayFor which are Tuition and Misc (there are more but I did not put it here). Since I cannot add two column headers, I added a new row header for the Remarks. However, when I type something on the remarks field, the studentName gets to be duplicated. Please help.

Max

 

[NauticalGent]

Hello maximrose,

I'm afraid I do not understand what your situation is. Can you explain it differently?

 

[maximrose]

Sorry for not being so clear. Please see image below.

 

[NauticalGent]

OK, I think I understand. Which table is the remarks in?

 

[maximrose]

Remarks is on the paymentdetail table. StudentName is on the Students table. PayDate is on the Payment table. Thanks.

 

[maximrose]

PayFor (Tuition, Misc, Others) is on the PaymentDetail table as well.

 

[stopher]

You can try summing the value fields and do Max on the remarks field.

 

[maximrose]

It works. Thanks.