Show "All" in Heading Of The Report

[cstuckey56]

In my report I added a text box in the header of the report to show the payment method I selected from the parameter query. So it shows: check, cash, PayPal, etc. I have other parameters in other fields I select for the report. Sometimes, when I run the query I leave the "pymt method" field blank to show all payment methods.

Here's what I want to do.

When I leave the "pymt Method" field blank to show all methods I want the text box in the header to say "All"

:banghead:

How can I do this?

Thanks in advance

 

[Brianwarnock]

I presume this textbox is populated from the parameter, instead populate it from a new col in the query which is
Eg
Parameterref: nz(yourparameterref,"ALL")

Thus when the parameter is blank ie null the field will be set to ALL

I don't know if this would just work In the report


Brian

 

[cstuckey56]

Let me clarify, when I say the parameter is "Null", I mean I do not put anything in the parameter to get all records or "Pymt Types." EX. Like [Enter Pymt Type] & "*" When I pulls all my records in the report it shows the first record "Pymt Type" of the first record like "check." the next record might be a "Paypal" type.