Search results

  1. A

    Query Criteria Not multiple fields with data

    Unfortunately, that doesn't work! I've put data in all fields with each type of data and nothing comes out for records. It looks sound but doesn't provide the output! :(
  2. A

    Query Criteria Not multiple fields with data

    The first two are in one field for criteria the second is in a different field. Field one is Status Update ECO Not "ERP UPDATE" And Not "CANCELLED" Field two is Status Update ECR Not "COMPLETED" Two separate fields with criteria that isn't required in the query. :o
  3. A

    Query Criteria Not multiple fields with data

    Okay so that takes care of the first field of Criteria. I also need to use another field to omit "COMPLETED" Not Like "COMPLETED" Thank you for the And Not Like that works much better. ;)
  4. A

    Query Criteria Not multiple fields with data

    I'm creating a query from one table using two fields that require certain records to NOT bring up records that have the following text: One table, two fields First field ECO LifeCycle Status Criteria is Not "ERP UPDATE" or "CANCELLED" Second field ECR LifeCycle Status Criteria is Not "COMPLETE"...
Top Bottom