Error

  • Thread starter Thread starter Aurora
  • Start date Start date
A

Aurora

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
 
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:
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
 
Back
Top