Parameter should return 0 Records

[Tom]

I need to create a parameter query that returns "no records" if I ignore the
parameter value message box and just press ENTER w/o entering any
characters.

Does anyone know how to do this?

Thanks,
Tom

 

[Douglas J. Steele]

Presumably you've got something like

WHERE Field = [Parameter]

right now.

Try

WHERE Field = [Parameter] AND [Parameter] IS NOT NULL