Making 3 fields from 1

[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

 

[Chris Nebinger]

Look into Crosstab Queries. It will do what you want to
do. Search the help file for details.


Chris Nebinger

 

[Mao Monsalve]

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


.