In case of empty formular get all the values

[sandordan]

Hi Everyone,



I would like to set a predefined value (all) in my query as criteria in case of the forms value is empty. If I tried with a value instead of "*" I have no problem with the query but at the using "*" I receive no values. I tried "nz" and "if" forms.

If([Formulare]![Produktionsumsatz]![werk]<>"";[Formulare]![Produktionsumsatz]![werk];"*")
nz([Formulare]![Produktionsumsatz]![werk];"*")

with like and without like, with value instead of "*" has no problem.

How can I give a criteria to get all value if I have no value in the Formular?

Thank you in advance.

[Minty]

Use [Formulare]![Produktionsumsatz]![werk] Or [Formulare]![Produktionsumsatz]![werk] is Null in the criteria.

[sandordan]

I used

If([Formulare]![Produktionsumsatz]![werk] Is Null;"*";[Formulare]![Produktionsumsatz]![werk])

no results

[sandordan]

and now

if([Formulare]![Produktionsumsatz]![werk] Is Null;Is Null;[Formulare]![Produktionsumsatz]![werk])

also without results

[June7]

Per Minty's suggestion, no If and no semi-colons:

WHERE [your field name here] = [Formulare]![Produktionsumsatz]![werk] Or [Formulare]![Produktionsumsatz]![werk] Is Null;