I am a newb with MS access and am getting the #error on my report when a query returns with EOF.
This is what I have done and the purpose of the report.
I primarily need a report that will provide the sales by category for a date range(provided by the user) and the sales for the same categories but for the year previous. I have created 2 queries that are identical, except the second query minuses the date inputed from the user by a year. What is happening is that some categories are new this year and did not appear last year and those records are coming up with no records and causing the #Error to appear on my report.
I have tried everything to trap it as a null value but alas nothing has succeeded. I am at a stand still. Please help.
No dice. The problem is not with handling a null value but that there is not a record to put a null value to. It gives an #error on the report when it cannot retrieve any data. What I want is that if it the query returns with no records to give me the value of 0.