Parameter query where one or more fields null

  • Thread starter Thread starter ERuth
  • Start date Start date
E

ERuth

I have a query in Access 2003 that I would like to use a form to select any
or all items from 3 fields. The fields are Station, Bin, Comm. At times I
would like to see all information and others be able to select one or a
combination of fields. I can get the query to work with one or IsNull field
but would like the option of being able to have all 3 fields be null if I
desired to see all records.
 
The criteria would be:

Like [Forms]![FormName]![ControlName] & "*" Or Is Null

That lets you enter any part of the text or nothing.
 
Back
Top