parameter query

  • Thread starter Thread starter Grace
  • Start date Start date
G

Grace

Hello, I have a parameter query that prompts for a value
in a field. Is there any way to leave the value blank so
that all the records display? Do I need code to do this?
If so, where would I put the code? On the query?

Thank you,
Grace
 
Hello, I have a parameter query that prompts for a value
in a field. Is there any way to leave the value blank so
that all the records display? Do I need code to do this?
If so, where would I put the code? On the query?

Thank you,
Grace
Click to expand...

You can use a criterion in the Query of

= [Enter search term:] OR [Enter search term:] IS NULL

Access will rearrange the query grid after you save the query but it
will work.
 
Back
Top