Making 3 fields from 1

  • Thread starter Thread starter Mao Monsalve
  • Start date Start date
M

Mao Monsalve

Hi

I have two fields: 1.calls and 2.priority, the priority
has records A, B and C

I have been trying to have total count of A,B and C group
by calls

in 3 different fields like:
CALLS | PRIORITY_A | PRIORITY_B | PRIORITY_C

any ideas
Thanks
Mao Monsalve
 
Look into Crosstab Queries. It will do what you want to
do. Search the help file for details.


Chris Nebinger
 
Thanks Chris Nebinger
YES I was looking for that
-----Original Message-----
Look into Crosstab Queries. It will do what you want to
do. Search the help file for details.


Chris Nebinger


.
Click to expand...
 
Back
Top