Error

I think he is referencing the "Use a form to enter report criteria" help section. Beware that there is an error with the "[Visible] = No" section of the Ok button Macro when converting your database to 2003.

"Aurora" wrote:

Steve:
Thank you for answering my question. I am not sure of
what you are suggesting when you say create a form to
enter the dates into. Do I create a form ([dateform]with
2 fields ([beg] & [end]. Then what? I am confused.

Aurora

-----Original Message-----
Aurora:

Any time a recordset or query returns no records, the
parameters (i.e. your
dates) are returned empty as welll so they can't be
referenced. The best
way to resolve this is to create a form for the user to
enter the dates in,
and then have your report's query reference those form
controls for the
starting and ending dates. Then too, your report can
reference those fields
for the header and you won't receive the "#error# result.
--
Steve Arbaugh
ACG Soft
http://ourworld.compuserve.com/homepages/attac-cg

"Aurora" wrote in
message
...
I am using Access 2000

I created a report which asks for a beginning and ending
date period. When this is entered it not only pulls the
information for that time period but puts the dates in
the
header. This works fine if there is data to pull. But
if
there is no data during the time frame, all I get
is "error" where the dates in the header should be. Why
does this happen? How can I get the dates to appear in
the header even if there is no data that meets the
criteria?

Aurora


.