Frequency Distribution question

[NC Tim]

Hello,
I think the question i have is fairly straightforward , but I can't seem to
replicate the old SAS frequency procedure when I try to accomplish this in
MS Access.

anyway, i have about 10 questions on a survey that have a possible response
range from 0-4.

what I would like to do is simply show that for each question we had x
amount of responses in each category, which amount to x percentage of all
responses:

so if we have the following responses to 5 surveys for question 1
1
2
2
3
4

the frequency distribution would look like:
1 1 20%
2 2 40%
3 1 20%
4 1 20%

I can get this (or at least the frequency) for one question by using a query
and selecting the field twice, then using groupby in the first column and
count in the second column. But if I try to do this for the next field in
the next 2 columns it screws everything up.

can someone help me?
thanks,
Tim Brooks

[Don Leverton]

Hi Dave,

I sent my "app" (not much there really) to your e-mail.

I also included what appears to be an Access 2.0 survey application that I
had downloaded from somewhere at some point. (Alzheimers?) :)
Tony Toews, possibly? The filename is survey.zip, which includes 2 files
SURVEYLB.MDB and SURVTEST.MDB.
I can't find anything that identifes the author inside of the application
either.

Anyway... This is more likely to be what you're looking for. If anyone else
is interested in this, post here and I'll send it.

Don

"Dave Brydon" <db*****@ns.sym patico.ca> wrote in message
news:HF******** ************@ur sa-nb00s0.nbnet.nb .ca...

Don,

My wife is considering a small survey at work, and is looking for options;
if possible, I would certainly appreciate an example of your database to
pass along to her.

Cheers,

Dave (db*****@ns.sym patico.ca)
(Please Zip file, or change extension, i.e. mydatabase.txt)

"Don Leverton" <le************ ****@telusplane t.net> wrote in message
news:36Agc.4938 2$aD.12596@edtn ps89...

Hi Tim,

I took this on as a challenge ... I like to do that occasionally as an
opportunity to learn. :)

Here's what I came up with, .......>

[Don Leverton]

Hi Dave,

I sent my "app" (not much there really) to your e-mail.

I also included what appears to be an Access 2.0 survey application that I
had downloaded from somewhere at some point. (Alzheimers?) :)
Tony Toews, possibly? The filename is survey.zip, which includes 2 files
SURVEYLB.MDB and SURVTEST.MDB.
I can't find anything that identifes the author inside of the application
either.

Anyway... This is more likely to be what you're looking for. If anyone else
is interested in this, post here and I'll send it.

Don

"Dave Brydon" <db*****@ns.sym patico.ca> wrote in message
news:HF******** ************@ur sa-nb00s0.nbnet.nb .ca...

Don,

My wife is considering a small survey at work, and is looking for options;
if possible, I would certainly appreciate an example of your database to
pass along to her.

Cheers,

Dave (db*****@ns.sym patico.ca)
(Please Zip file, or change extension, i.e. mydatabase.txt)

"Don Leverton" <le************ ****@telusplane t.net> wrote in message
news:36Agc.4938 2$aD.12596@edtn ps89...

Hi Tim,

I took this on as a challenge ... I like to do that occasionally as an
opportunity to learn. :)

Here's what I came up with, .......>