W
William R. Hess
Hello
New to Access and trying to figure out a problem with an AND test
I have a database with 4 fields called A B C D
Field A Must =1 (no problem with this)
Field D Must > 1 (Again no problem)
Fields B & C can be any number including zero, as long as BOTH fields are
not zero. If I search using the criteria for fields A & D only, I find 390
records. If I search with criteria that says show me if both are zero,
(B=0, C=0 on the criteria line, along with the other criteria) it shows me
the 4 or so suspect records that have a zero in BOTH fields. If I use the
opposite, and use B<> 0, C<> 0, A =1 & D>1 on the criteria line, it is
returning 241 records. It appears to be omitting the records if EITHER of
the fields are zero
Is there a way where I'm supposed to 'enclose' the criteria for B & C in
parenthesis ala Excel so they are evaluated together?
Suggestions or ideas appreciated!
-Bill
New to Access and trying to figure out a problem with an AND test
I have a database with 4 fields called A B C D
Field A Must =1 (no problem with this)
Field D Must > 1 (Again no problem)
Fields B & C can be any number including zero, as long as BOTH fields are
not zero. If I search using the criteria for fields A & D only, I find 390
records. If I search with criteria that says show me if both are zero,
(B=0, C=0 on the criteria line, along with the other criteria) it shows me
the 4 or so suspect records that have a zero in BOTH fields. If I use the
opposite, and use B<> 0, C<> 0, A =1 & D>1 on the criteria line, it is
returning 241 records. It appears to be omitting the records if EITHER of
the fields are zero
Is there a way where I'm supposed to 'enclose' the criteria for B & C in
parenthesis ala Excel so they are evaluated together?
Suggestions or ideas appreciated!
-Bill