G
Guest
How can I create a query to exclude records containing certain words like the
word "accept". If I have multiple fields containing this word "accept" and
"fail" how can I exclude all records with these words from each field?
I have 3000 records with 5 fields that have this word in many records. I
only want to see records that do not have these words "accept" and "fail". I
also have many records with blank fields in any of the 5 fields. I don't
want blank records to affect my sort/criteria accuracy. I've tried using not
"accept" and not "fail" as a criteria but this does not work accurately when
I move over to next field. Also, when should criteria be on one line in
design view and when should criteria be typed into two lines (one above the
other)?
Using Access 2000 with Windows XP.
word "accept". If I have multiple fields containing this word "accept" and
"fail" how can I exclude all records with these words from each field?
I have 3000 records with 5 fields that have this word in many records. I
only want to see records that do not have these words "accept" and "fail". I
also have many records with blank fields in any of the 5 fields. I don't
want blank records to affect my sort/criteria accuracy. I've tried using not
"accept" and not "fail" as a criteria but this does not work accurately when
I move over to next field. Also, when should criteria be on one line in
design view and when should criteria be typed into two lines (one above the
other)?
Using Access 2000 with Windows XP.