Hi,
I created a query to show only the records between 2 specific dates. If there are no records between those dates I want the query (and report) to show 0.
Is it possible to do this? If so, how?
Thanks
Below is the query. I want to show a value of 0 if there is no records.
Any suggestions?
Thanks
SELECT [Expense Details].Category, Sum([Expense Details].ExpenseItemAmount) AS SumOfExpenseItemAmount
FROM [Expense Details]
WHERE ((([Expense Details].[Expense Date]) Between #1/1/2005# And #12/31/2005#))
GROUP BY [Expense Details].Category
HAVING ((([Expense Details].Category)="FEES"));
If you are basing a report on a query and the query returns no records, the report won't work. You can use the On No Data Event to produce a message that there are no records or change the Recordsource to a dummy table that returns a blank record.
