Query Help

  • Thread starter Thread starter James McDonald
  • Start date Start date
J

James McDonald

I need my query to list our offices, then list the
quantity of call types that they received.

For example:

Office Type Number of calls
Jack Sale 3
Order Prob 6
Odr not Rec 2

Phil Sale 6
Order Prob 2
Odr not Rec 1

The easier the instructions the better due to my limited
knowledge of Access.
Thank You
 
I need my query to list our offices, then list the
quantity of call types that they received.

For example:

Office Type Number of calls
Jack Sale 3
Order Prob 6
Odr not Rec 2

Phil Sale 6
Order Prob 2
Odr not Rec 1

The easier the instructions the better due to my limited
knowledge of Access.
Thank You
Click to expand...

The instructions will be a heck of a lot easier to write if we had
some clue about how your table is structured and where in your table
we might be able to calculate the number of calls.

A Totals query, grouping by Office and Type, and counting - something,
I don't know what since I can't see your table - would be indicated.
To create one create a Query based on your table, click the Greek
Sigma icon (looks like a sideways W), and Group By Office and Type on
the totals line; select Count on some other field, such as the CallID
or CallDateTime.
 
Back
Top