Criteria Expression Question

[Guest_imported]

I want the Criteria portion of a row in Query to say "if XX is not null, then match to XX, otherwise match all" (imagine XX is a data item thats being fed to the query)

My expression right now looks like this:

IIf(XX & " Is Not Null",XX,Is Not Null)

it only works when XX isn't null because otherwise I guess it returns a String "Is Not Null", as opposed to the actual function. Is there something I can put a string that would match all data?

Otherwise, any suggestions would be appreciated.

Thanks

 

[CosmoKramer]

Try:

IIf((Not IsNull([XX])),[XX],"*")

 

[Guest_imported]

Regretfully that doesn't work. I think Access tries to actually match with a row that has the character * as its data.

 

[Guest_imported]

Regretfully that doesn't work. I think Access tries to actually match with a row that has the character * as its data.