I built a really good database and now I want to dress it up a bit. Does anyone know how to change the color of a command button ? (access 2003)
Thanks:rolleyes:
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...
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