Parameter should return 0 Records

  • Thread starter Thread starter Tom
  • Start date Start date
T

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
 
Presumably you've got something like

WHERE Field = [Parameter]

right now.

Try

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