Query Returns Zero

[spcepickle]

Hi All - I have two queries that look up information on projects completed. The first looks up month to date and the second year to date. I also have a report that shows both queries - > Project Type, Count of Projects Completed and the Sum of the Cost.

The problem - If a given project type has not been completed in the last month then the year to date count does not show up.

Is there a way to force a query to return a zero value?

Thanks!

 

[georgedwilkinson]

Use a union query? In the second part of the union query get your "not completed" result set and select "0" into the field in question.

There may be other ways...if this doesn't work, post your sql.