Date in report header showing Error# (DON'T want to cancel report)

  • Thread starter Thread starter Duane Hookom
  • Start date Start date
D

Duane Hookom

You can't get a parameter prompt value to show in a query that doesn't
return any rows. Consider junking all parameter prompts in favor of values
from controls on forms. This is much more flexible, functional, and
powerful.
 
I have a report whose source is a query. In the query, the Date field has a
criteria prompt for the user to set at runtime. The report header has a
field whose source is "=[Enter Date]" (which is the prompt in the query).
It all looks and works great unless there are no records returned by the
query.

Now, I don't want to cancel the report, I want the 0 (zeroes) to show up,
and in the footer I have Dcounts and calculated fields and things that show
that fine (showing zeroes and zero percentages, etc.), but the Date in the
report header (=[Enter Date]) shows Error# when there are no records. How
can I set the field to show what was entered as the parameter even if no
records are returned?

I looked for this in the newsgroups, but it appears everyone was always
happy with just cancelling the report, instead of actually printing it and
showing the zero values.

Thanks for any help
 
Back
Top