Crosstab with cumulatives in the columns

[Bob Alston]

Can someone suggest how I can create cumulatives in the columns of a
crosstab?

I have data on client enrollments. I can easily get a cross tab showing
how many enrollments by month
Jan feb mar apr may jun ..................
Enrollments 1 3 5 2 6 0


what I would like is to have an enrollments to date in the column
Jan feb mar apr may jun ..................
Enrollments 1 4 9 11 17 17

suggestions on how I can do this?

My data is like this:

last name
First name
Enrollmentdate
So Adams John Jan 5, 2006
Nichols Helen Feb 13, 2006
Smith Tim Feb 4, 2006
..
..

Thanks

[Bob Quintal]

Bob Alston <bo********@yahoo.comwrote in
news:ei*************@newsfe04.lga:

Can someone suggest how I can create cumulatives in the
columns of a crosstab?

I have data on client enrollments. I can easily get a cross
tab showing how many enrollments by month
Jan feb mar apr may jun
..................
Enrollments 1 3 5 2 6 0


what I would like is to have an enrollments to date in the
column
Jan feb mar apr may jun
..................
Enrollments 1 4 9 11 17 17

suggestions on how I can do this?

My data is like this:

last name
First name
Enrollmentdate
So Adams John Jan 5, 2006
Nichols Helen Feb 13, 2006
Smith Tim Feb 4, 2006
.
.

Thanks

Ooooh! a challenge. First you need to get the cumulative by
month number .Get the enrollment_count by year and month using a
Summation Query. then get the cumulative in a second query,
based on the first, using dSum() function with a whereClause
that makes Qry1year = Qry2year and qry1month <= qry2month

Build the Crosstab query around the second query.

--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com