Criteria in a query

  • Thread starter Thread starter Krish
  • Start date Start date
K

Krish

In a select query I have added a criteria to a field as ["Enter
Department:"]. If no department is entered in the box that is prompted, I
get no results. How do I make the query to display all departments, if no
department is entered in the prompt box?

Thanks for the help
 
Krish,

Change your criterion in the query design to:

Like ["Enter Department:"] & "*"

HTH,
Nikos
 
In a select query I have added a criteria to a field as ["Enter
Department:"]. If no department is entered in the box that is prompted, I
get no results. How do I make the query to display all departments, if no
department is entered in the prompt box?

Thanks for the help
Click to expand...

Where YourTable.[Department] = [Enter Department] or [Enter
Department] Is Null
 
Back
Top