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

sum or count

P: n/a
The database I am working with contains a field with as many as 12
different values (09,10,11,12,13,14,15,16,17,18,19,20)

My end user has requested that the number of times these 12 different
values appear in the table be grouped in the following 8 groups (15 or
19), (13 or 17), (16 or 20), (14 or 18), (09), (11), (12), (10)

That is, for example, the end user wants the combined count for the
total number of times (15 or 19) appears in the table.

I created 8 queries for the above 8 groups (15 or 19), (13 or 17), (16
or 20), (14 or 18), (09), (11), (12), (10) though I don't think the
queries for the 4 groups containing two possible values work correctly
or any of them for that matter.
How do I set up my query for these 8 groups?
And especially how do I do this for the 4 groups containing two
possible values?

How do I show, on a report, only the the counts for the number of times
these 8 groupings show in the table?

Nov 15 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
jmarr02s wrote:
The database I am working with contains a field with as many as 12
different values (09,10,11,12,13,14,15,16,17,18,19,20)

My end user has requested that the number of times these 12 different
values appear in the table be grouped in the following 8 groups (15 or
19), (13 or 17), (16 or 20), (14 or 18), (09), (11), (12), (10)

That is, for example, the end user wants the combined count for the
total number of times (15 or 19) appears in the table.

I created 8 queries for the above 8 groups (15 or 19), (13 or 17), (16
or 20), (14 or 18), (09), (11), (12), (10) though I don't think the
queries for the 4 groups containing two possible values work correctly
or any of them for that matter.
How do I set up my query for these 8 groups?
And especially how do I do this for the 4 groups containing two
possible values?

How do I show, on a report, only the the counts for the number of times
these 8 groupings show in the table?
What's wrong with your email program. You seem to post multiple
question that are the same.

Besides that annoyance, have you thought of creating a lookup table.
Create a table with 3 fields; ID (auto), GroupDesc (enter "15 or 19") 2
times, and in the third column enter 15 and in the second record 19.
Now you can link this table to your query to get counts easily.
Nov 15 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.