spcepickle
Registered User.
- Local time
- Today, 12:47
- Joined
- Jan 8, 2008
- Messages
- 30
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!
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!
