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...