Criteria in a query

[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

 

[Nikos Yannacopoulos]

Krish,

Change your criterion in the query design to:

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

HTH,
Nikos

 

[fredg]

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

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