Need several totals - Don't where to start

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Please assist

Need totals on

3 groups

group 1: certain titles belong to exec group
group 2: people with sales > 10
group 3: muchkins group

Count 1: How many in each group
and
within each group
total of each class attended

Total count of ea grp Total count of grp attendees
Class1, class2
Group 1
Group 2
Group 3

Thx
gdev
 
Please assist

Need totals on

3 groups

group 1: certain titles belong to exec group
group 2: people with sales > 10
group 3: muchkins group

Count 1: How many in each group
and
within each group
total of each class attended

Total count of ea grp Total count of grp attendees
Class1, class2
Group 1
Group 2
Group 3

Thx
gdev
Click to expand...

Gwen, *you* know the structure of your tables, what a "group" is, and
what it is that you're totalling. We don't. We cannot see your
database.

What is the structure of your Table?

My GUESS - based on trying to figure out your post - is that you will
need a calculated field in the Query for each total. It would be
something like

IIF([Title] IN ("Poobah", "High Exalted Potentate", "Grand
Inquisitor"), 1, 0)

IIF([Group] = "muchkin", 1, 0)

or whatever criteria you have; you could then Sum these calculated
values.

John W. Vinson[MVP]
 
Thanks for responding. Sorry for the confusion

Sorry for the confusion.

Table Structure:

id num
lname
fname
title
class attended
number of sales
area


These are questions my query need to answer:

for all execs How many execs?
for all munchkins How many muchkins?
for all in area1 How many in area1
for all with sales > 10 How many humans with more than 10 sales

How many execs have taken class1, class2 class3?
How many muchins have taken class1, class2 class3?
How many supersalesman have taken class1, class2 class3?
How many in area1 have taken class1, class2 class3?

Thx, gwen

John Vinson said:
Please assist

Need totals on

3 groups

group 1: certain titles belong to exec group
group 2: people with sales > 10
group 3: muchkins group

Count 1: How many in each group
and
within each group
total of each class attended

Total count of ea grp Total count of grp attendees
Class1, class2
Group 1
Group 2
Group 3

Thx
gdev
Click to expand...

Gwen, *you* know the structure of your tables, what a "group" is, and
what it is that you're totalling. We don't. We cannot see your
database.

What is the structure of your Table?

My GUESS - based on trying to figure out your post - is that you will
need a calculated field in the Query for each total. It would be
something like

IIF([Title] IN ("Poobah", "High Exalted Potentate", "Grand
Inquisitor"), 1, 0)

IIF([Group] = "muchkin", 1, 0)

or whatever criteria you have; you could then Sum these calculated
values.

John W. Vinson[MVP]
Click to expand...
 
Back
Top