Encorporating a Left Join query into a Criteria query

[Workaholic]

I've created a query using a left join that shows the number of calls every office has placed to a helpdesk overall from a table. The query includes every office and offices that have not placed a call show a zero in the count.

My problem is that I now want to show how many calls where made in a select month and yet still show all the office names and zeros for the offices that did not make any calls in that month.

How do I encorporate the left join query into a criteria query.

 

[Mile-O]

Make a query that does the select as normal.

Base a second query (with your left join) on this query.

 

[Workaholic]

Fantastic I was doing it the other way, putting the cart before the horse.

How can I make the count function display the nulls as zeros?




Two snowmen in a field, one turns to the other and says 'Can you smell carrots?'