show values of query parameters in report when no data is returned

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an Access database and I can get the query parameters to display fine
in the Report header if data is returned from the query.
The problem is that when no data is returned by the query, the query
parameters are not displayed in the Report Header and I see #Error instead.
What can I do in this case?
 
Replace you parameter prompts with references to controls on forms. Your
criteria might be something like
Between Forms!frmA!txtStart and Forms!frmA!txtEnd
You can then reference the controls in control sources on your report.
 
So I guess there's no other way than to create a form and pass in the
parameters that way. I was hoping to not have to do that since this was a
quick modification of an already existing query. :-(
Thanks.
 
Back
Top