PARAMETER QUERY - (1 Viewer)

[Doneberhart]

I'm trying to get my report to show the parameter even if there is no data. I can get it to show the parameter if there is data but it shows #error# if there is no matching data.

 

[Lou]

Try using as iif statement in the Control Source such as:

=iif([beer_sales]>0,sum([beer_sales]),0)

I am assuming that you are dealing with blank data fields.

Hope this helps.
...Lou