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?  
Share this Question
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.   This discussion thread is closed Replies have been disabled for this discussion.   Question stats  viewed: 1367
 replies: 1
 date asked: Nov 15 '06
