filtering fields to get a count?

[zSplash]

I want a report that lists the number of events handled by specific
individuals. That is, my table has various possible events (say A, B, C,
and D), and who handled each event (say Adam and Bob). I want the report to
show:
Adam: Bob:
A: 45 165
B: 102 69
C: 45 400
D: 9 55

(of course, there are more people and more events)

How do I create such a report? (I don't think I know how to fashion the
query, among many other things!) Each event is stored as a date, and each
event has a dateWho. If I make a query of all events and all eventWho's,
and try to filter the query by ="Adam", for example, my query is empty.

TIA

 

[Marshall Barton]

I want a report that lists the number of events handled by specific
individuals. That is, my table has various possible events (say A, B, C,
and D), and who handled each event (say Adam and Bob). I want the report to
show:
Adam: Bob:
A: 45 165
B: 102 69
C: 45 400
D: 9 55

(of course, there are more people and more events)

How do I create such a report? (I don't think I know how to fashion the
query, among many other things!) Each event is stored as a date, and each
event has a dateWho. If I make a query of all events and all eventWho's,
and try to filter the query by ="Adam", for example, my query is empty.

That looks like a crosstab query (there's a query wizard
that helps). BUT, it sounds like your data is not properly
normalized, which, if true, will seriouly get in the way of
any attempt to accomplish your goal.

If your table records look like
Person EventA EventB . . .
you are in serous trouble and need to rearrange the data so
it looks like:
Person Event
Bob EventA
Adam EventC
Adam EventA
Adam EventD
Bob EventC
Bob EventB
Bob EventC
This way, a cross tab query will do what you want and the
report should be very simple.

 

[zSplash]

Thanks, Marshall.
No, that's not how my table's set up; that's just how I want to display the
data.
I'll try a crosstab query and let you know if it works.

 

[zSplash]

The trouble is, I have about 15 events, and 5 people (so far). The
cross-tab wizard only let's me choose 3 tops.

Thanks, Marshall.
No, that's not how my table's set up; that's just how I want to display
the data.
I'll try a crosstab query and let you know if it works.

 

[Marshall Barton]

I don't understand. I thought you wanted the row heading to
be the event field and the column headings to be the person
field.

Where does the limit of 3 come into it?

 

[zSplash]

Thanks, Marshall. Yes, that's exactly what I want. But, when I try to use
the crosstab query wizard, it indicates I can only select 3.

I don't understand. I thought you wanted the row heading to
be the event field and the column headings to be the person
field.

Where does the limit of 3 come into it?
--
Marsh
MVP [MS Access]

The trouble is, I have about 15 events, and 5 people (so far). The
cross-tab wizard only let's me choose 3 tops.

 

[Marshall Barton]

What you are saying still doesn't make sense. You have one
event field to use as the row heading. What else is
there???