Return records based on user input

[shaggy]

WHERE iif([Enter value] is null, [FieldName] is null, [FieldName]=[Enter value])

The above works to return records with a value entered for a field, or all records with a null value in that field if there is no user input.
-----------------------------------------------------------------------------------------------------------------------------
I'm now trying to return records with a value entered for a field or any non-null value in that field if there is no user input.

WHERE iif([Enter value] is null, [FieldName] is not null, [FieldName]=[Enter value])

The above works if a value is entered, but not if there is no user input. Any help would be greatly appreciated.

 

[Rob.Mills]

Try:

WHERE iif(IsNull([Enter value]), [FieldName], [FieldName]=[Enter value])