Return all records in a parameter query

[Alex]

I'm going crazy. I know there's a way to add criteria in a parameter query
that will return all records if the parameter box is left blank. I've done
it before but I can't find it in the help system or in here (surely because
I'm typing my question incorrectly).

I have a field called Bldg. I'd like people to type a bldg. or to leave it
blank and return all records. I'm not using a form, just a plain old
parameter.

Thanks in advance for your help.

 

[Douglas J. Steele]

WHERE Bldg = [What Building?] Or [What Building?] Is Null

Note that it's critical that the two references to the parameter be typed
identically.

You can also extend the above so that they only have to type in part of the
Building Name:

WHERE Bldg Like "*" & [What Building?] & "*" Or [What Building?] Is Null

 

[Ofer]

Try using

Where FieldName Like NZ([Parameter],"*")