Re: Multiple fields, same criteria
- From: "Rick B" <Anonymous>
- Date: Thu, 18 Jan 2007 10:01:24 -0600
If you are in the query design grid, just put your criteria under the first
field. Something like...
="Low"
Then, on the next row under the next field, put your criteria. Then on the
next row under the next field, put your criteria. Etc.
Placing the criteria on separate rows creates and "OR" condition. Placing
the criteria on the same row would create a condition where all the criteria
must be true.
--
Rick B
"kvail" <kvail@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:36D83C88-81EE-4DD4-8F05-B010DB2FB109@xxxxxxxxxxxxxxxx
I have a query with 23 fields regarding customer service satisfaction
survey.
11 of the fields are individual question results on the survey.
I need a query that says "IF ANY ONE OF THESE 11 FIELDS CONTAINS a low
rating then add it to the list" or suppress any record in which ALL 11
fields are a high rating. If one of the 11 fields contains a low rating
and
the other 10 have high ratings, then I do what that record.
.
- Prev by Date: text to number format or preceeding 0
- Next by Date: Label Count
- Previous by thread: text to number format or preceeding 0
- Next by thread: Label Count
- Index(es):
Relevant Pages
|
Loading
