Need help with Query result display

[sonname]

I have a query that produces the following results.

class, division, count, status
86 50 200 Approved
86 50 67 Not Approved

Is there a way I can get it so that it displays in the following manner?

class, division, Approved, Not Approved
86, 50, 200, 67

Basically I want to combine the class and division and make the status as part of the column headings.

 

[gmmastros]

What have you tried?

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[PWise]

Select Class,Division Sum(iif(Status="Approved",1,0)) as Approved, Sum(iif(Status="Not Approved",1,0)) as NotApproved
From QueryName

 

[PWise]

Sorry gave you access Syntex

try

Select Class,Division Sum(Case when Status='Approved' then 1 else 0 end ) as Approved, Sum(Case when Status='not Approved' then 1 else 0 end ) as NotApproved
From QueryName

 

[bborissov]

You miss GROUP BY

Select Class,
       Division,
       Sum(Case when Status='Approved'
                then 1
                else 0 end ) as Approved,
       Sum(Case when Status='Approved'
                then 0
                else 1 end ) as NotApproved
From QueryName 
GROUP BY Class, Division

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.
Microsoft MVP VFP

 

[sonname]

Thank you all. Works great.