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.

--
Duane Hookom
MS Access MVP
--

"rgrantz" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>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
>
>
>
>

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