What's the Problem with this query?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am running a select query on a table with 10 descriptive fields for each
record. I am using two field to set criteria. The first select field is a 3
digit number. I set the criteria on two lines. Criteria = ">0 And <=399" and
Or = ">399 And <= 999". My query applies this correctly (I get all records
except the 400s).

The second select field is a check box. Criteria = "=Yes". When I run the
query with both select fields in the query, I get some of the records with
unchecked boxes but on all. When I run the query without the first select
field (the 3 digit number), the query runs correctly (I get only records that
are checked).

What am I doing wrong?

PS: When I run the combined selection to produce just the 400's, ( Criteria
= ">= 400 And <500") I get perfect results.
 
I GOT IT!! All I had to do was to set the OR line under the 3 digit number
field to "Yes", also. I just learned someting!!!!!!!!!
 
Back
Top