Crosstab Query with more than one column header (1 Viewer)

maximrose

New member
Local time
Tomorrow, 03:22
Joined
Jun 1, 2016
Messages
6
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

Ignore List Poster Boy
Local time
Today, 15:22
Joined
Apr 27, 2015
Messages
6,286
Hello maximrose,

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

maximrose

New member
Local time
Tomorrow, 03:22
Joined
Jun 1, 2016
Messages
6
Sorry for not being so clear. Please see image below.
 

Attachments

  • crosstab.JPG
    crosstab.JPG
    47.9 KB · Views: 131

NauticalGent

Ignore List Poster Boy
Local time
Today, 15:22
Joined
Apr 27, 2015
Messages
6,286
OK, I think I understand. Which table is the remarks in?
 

maximrose

New member
Local time
Tomorrow, 03:22
Joined
Jun 1, 2016
Messages
6
Remarks is on the paymentdetail table. StudentName is on the Students table. PayDate is on the Payment table. Thanks.
 

maximrose

New member
Local time
Tomorrow, 03:22
Joined
Jun 1, 2016
Messages
6
PayFor (Tuition, Misc, Others) is on the PaymentDetail table as well.
 

stopher

AWF VIP
Local time
Today, 19:22
Joined
Feb 1, 2006
Messages
2,396
You can try summing the value fields and do Max on the remarks field.
 

Users who are viewing this thread

Top Bottom