Need help

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

Guest

Hi all,

I'm having a problem I hope you guys would help me. I appreciate for your
help.
in my Crosstab query I have 3 columns such as
Office Case file type FileOfCount
R11 a P 1
R12 b E 2
Y11 c E 1
rowh rowh count and column
on the report I want the FileOfCount column break to two column one will
have Pcount and Ecount look like this
Office Case file type FileOfCountP fileOfCountE

R11 a p 1 2

Thank you very much for you time .
 
Will not work the way you laid it out as P is in office
R11 and the E's are in office R12 and Y11.
 
Back
Top