Allow Nulls

[RobM76]

Hi There,

I am having problems with a report.

I have selection perameters in the selection expert which are excluding nulls and I need it to allow nulls.

On the selection expert I have a few fields but the one I am having trouble with is the paymentmethod field which is using a "is one of" option and the formula shows the folowing

{bookings.Location} in ["Admirals Mews", "Admiral's Mews", "Celtic Haven", "Saundersfoot", "Waterwynch"] and
{bookings.datearrive} in DateTime (2008, 01, 01, 00, 00, 00) to DateTime (2008, 01, 31, 00, 00, 00) and

{bookings.paymentmethod} in ["*", "Agency 1", "card", "cash", "cheque", "Provisional"]

I there a way of putting in the "in" brachets Null, or is there another way of allowing nulls??

Thanks

 

[tpeters1]

How about this?

((isnull({bookings.Location})) or ({bookings.Location} in ["Admirals Mews", "Admiral's Mews", "Celtic Haven", "Saundersfoot", "Waterwynch"]))

 

[RobM76]

Thats worked.

Thank you very much.

Genius!