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
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