Queries

[Carp]

Hello,
I am trying to run a query to find every instance that a number lower than
255 appears in a field for each record. The query should run for several
fields for each record. I have tried typing <255 in criteria, but I am
having a problem. If one of the fields in the record ever has a number
greater than 255, then that record does not show up when I run the query.
What I am trying to do is run a query that will indicate anytime a number
smaller than 255 appears in any field on a record.

Any help would be appreciated. Thanks!

 

[KARL DEWEY]

Open the query in design view.
Put the criteria <255 for each field you are concened with BUT in a
different row -- 1st field - 1st row, 2nd field - 2nd row, 3rd field - 3rd
row, etc.

 

[Marshall Barton]

Hello,
I am trying to run a query to find every instance that a number lower than
255 appears in a field for each record. The query should run for several
fields for each record. I have tried typing <255 in criteria, but I am
having a problem. If one of the fields in the record ever has a number
greater than 255, then that record does not show up when I run the query.
What I am trying to do is run a query that will indicate anytime a number
smaller than 255 appears in any field on a record.

Try putting the <255 on different criteria rows. When they
are on the same criteria row, all of them must be true
(AND), on separate rows then any one or more of them can be
true (OR).