Query Problem--> returning wildcard

  • Thread starter Thread starter grantschneider
  • Start date Start date
G

grantschneider

I created a query that is linked to a form where I created a drop down
list to choose which values to include in the query. Currently, the
form works when I am trying to return only specific values but I
cannot figure out how to return all values.

The criteria and parameter is currently: [Forms]![SVP]![SVP]
 
Switch the query to SQL View (View menu.)

In the WHERE clause, replace:
[Field1] = [Forms]![SVP]![SVP]
with:
(([Forms]![SVP]![SVP] Is Null) OR ([Field1] = [Forms]![SVP]![SVP]))

(Use your own field name instead of Field1.)

If you have several of these fields, this approach will be more efficient:
Search form - Handle many optional criteria
at:
http://allenbrowne.com/ser-62.html
 
Back
Top