Crosstab question

[Stacey]

Hello,
I have a crosstab query built on another query. One of the fields is named [Doc]. I have that field set to Group By, as a column heading. There are two values possible, Pass and Fail. I need both Values to appear as fields on a report. My problem is, currently, there are no entries for Fail. So I am getting an error when running the report based on this query. How can I do this?

TRANSFORM Count([Function Doc Pass/Fail Summary].[Policy Number]) AS [The Value]
SELECT [Function Doc Pass/Fail Summary].Function, Count([Function Doc Pass/Fail Summary].[Policy Number]) AS TotalOfPolicyNumber
FROM [Function Doc Pass/Fail Summary]
GROUP BY [Function Doc Pass/Fail Summary].Function
PIVOT [Function Doc Pass/Fail Summary].[Policy/IRS Rules];

Thanks
Stacey

 

[ByteMyzer]

How about:

TRANSFORM Count([Function Doc Pass/Fail Summary].[Policy Number]) AS [The Value]
SELECT [Function Doc Pass/Fail Summary].Function, Count([Function Doc Pass/Fail Summary].[Policy Number]) AS TotalOfPolicyNumber
FROM [Function Doc Pass/Fail Summary]
GROUP BY [Function Doc Pass/Fail Summary].Function
PIVOT [Function Doc Pass/Fail Summary].[Policy/IRS Rules] IN ('Pass','Fail');

 

[Stacey]

Lovely! Worked like magic.....
Thank you!