Displaying 0's

[O.92]

Name: Image Attachment.PNG  Views: 12  Size: 14.7 KB  ID: 23046" class="thumbnail" style="float:CONFIG" />

I have a query output attached.

As seen, it gives me the number of each person's jobs that have been open over 60 days (Y) and the number that haven't (N). The issue is, for Carly Geer, I need it to show a 0 for Y, even though she has no jobs over 60 days.

How can this be done?

Here's my query SQL if it helps:

SELECT [Opens Source].[Recruiter Level 6], [Opens Source].[Recruiter Level 7], [Opens Source].[60+ Days], Sum([Opens Source].[Openings with No Offers + Offer Accept]) AS [SumOfOpenings with No Offers + Offer Accept]
FROM [Opens Source]
WHERE ((([Opens Source].[Opportunity Type])<>"CAMPUS POST & SCREEN"))
GROUP BY [Opens Source].[Recruiter Level 6], [Opens Source].[Recruiter Level 7], [Opens Source].[60+ Days];

[ranman256]

Create a 'fake' result query of every person and give everyone a zero.
Then take your query above and union to the fake zero query.
Sum them.
Q1 , your query
Q2, select person, 0 as Sum
Q3,
select * from Q1
union
select * from Q2

Q4 , the sum of Q3