Search results

  1. B

    multiple criteria in select query with 1 like

    I see (2) We may also occasionally see a solution like this:- ------------------------------------- Field: FieldName Show: check Criteria: Like "*" & [Forms]![FormName]![ControlName] & "*" ------------------------------------- Unfortunately, the Like operator cannot return Null values. So...
  2. B

    multiple criteria in select query with 1 like

    Hi, I'm trying to build a select query where it prompts the user for a few parameters. I've been having issues where people would misspell the vendor name and nothing pops up. I changed the vendor to Like [Vendor Name] & "*" but now I can't use the parameter of PO# without everything popping...
Back
Top Bottom