Click to See Complete Forum and Search --> : Help with Cross-Tab


shefe
November 4th, 2007, 12:12 PM
hello all,

Can someone help me with cross-tab with students registered for fall and spring, I need to know the count of the TOTAL of (2) to determine the student that came in for both fall and spring which to is Full year Student

Student Name Fall Spring Total
Aaron 1 1 2
Malahoo 1 1 2
Desty 1 1 2
Escayg 1 0 1
Adey 1 0 1
Adrian 1 0 1
Jewett 1 1 2
Kiel 1 0 1

tgarner444
November 5th, 2007, 12:01 PM
Sure, run a simple (but hidden) standard report below the crosstab which, using a running total, counts only those student IDs with term total of 2.

Show only the result of the running total.