By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,398 Members | 957 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,398 IT Pros & Developers. It's quick & easy.

Crosstab with cumulatives in the columns

P: n/a
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
Oct 9 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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

Oct 9 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.