looking for one selection criteria in multiple fields

  • Thread starter Thread starter DChitwood
  • Start date Start date
D

DChitwood

RE: Access 2000

how should I construct a query so that it looks through 20
different fields to find the selection criteria? The way
I'm doing now seems to be construing it to mean that all
fields must equal 2000, when what I'm wanting is for it to
pull the desired information where any one of the 20
fields = 2000.
 
-----Original Message-----
RE: Access 2000

how should I construct a query so that it looks through 20
different fields to find the selection criteria? The way
I'm doing now seems to be construing it to mean that all
fields must equal 2000, when what I'm wanting is for it to
pull the desired information where any one of the 20
fields = 2000.

.
Click to expand...
Hopefully, this is what you are looking for:
Select the fields you want in your query. Then, put your
criteria below each of the fields you want to search.
Instead of putting them all on the first criteria row, put
each of them on a different row. If you look at the far
left of the criteria row, it says "Criteria" and then "Or"
right below it. So view each consectutive line as
another "Or" statement. (i.e. Field1 = 2000 OR Field2 =
2000 OR Field3 = 2000, etc.). You can put varying
criteria on combinations of fields too.
Hope this helps.

Field1 Field2 Field3 Field4
2000
2000
2000
2000


Barry
 
DChitwood said:
RE: Access 2000

how should I construct a query so that it looks through 20
different fields to find the selection criteria? The way
I'm doing now seems to be construing it to mean that all
fields must equal 2000, when what I'm wanting is for it to
pull the desired information where any one of the 20
fields = 2000.
Click to expand...
How come you have 20 fields to look in? What are the names of these
fields? If they contain information on how they differ, your design may
need review.
 
Back
Top