How to query for recors where filed 1 = a or b or c OR if field 2= a, b , c OR field 3...

[Russellh]

I need to pull all records where either FIELD 1, FIELD 2, or Field 3 have a value of 60, or 61, or 63.



In design view I can do it for 1 field by just adding 60,61,63 in the OR sections underneath the field. But how do I add the others?

[pbaldy]

Sounds like a normalization issue, but put this in the criteria, on a different line for each field (creating an OR):

In(60, 61, 63)

[Russellh]

I get the expression is too complex error when I try to run it with In(60, 61, 63)

[orange]

As Paul said, put the In(60, 61, 63) on different rows to create an OR condition.

Your graphic shows these criteria all on the same row--which is not what Paul said.

[Russellh]

As Paul said, put the In(60, 61, 63) on different rows to create an OR condition.

Your graphic shows these criteria all on the same row--which is not what Paul said.

I get the same error when I do it like this.

[orange]

Well, Paul's first thought was you may have a Normalization issue. It seems that is true.
Two tables, no PK evident. No supporting info.

I think you'll have to tell us a lot more about your business in plain English and where this database fits. Until readers understand what you are dealing with, and what your data base is about, the best we can do is throw out a generic response to your generic question.

[pbaldy]

If the fields are text, you'd need to wrap each number in quotes. Make sure problem isn't on the other criteria, which would have to be repeated.

And you certainly have a normalization problem:

Fundamentals of Relational Database Design -- r937.com

[Russellh]

If the fields are text, you'd need to wrap each number in quotes. Make sure problem isn't on the other criteria, which would have to be repeated.

And you certainly have a normalization problem:

Fundamentals of Relational Database Design -- r937.com

Fields are txt. When I added the quotes it seems to only pull records that have the wanted codes in the Reoccur2 Code field and not the others.
This Database is created by a Software Company that provides us with our Customer Information System. They allowed us to install and ODBC connection and read the tables (no modification) to build our own custom reports.
They are not going to change the format of the database just for myself.

Any other ideas?

[pbaldy]

Did you copy the criteria in the far right column down as suggested?

[Russellh]

Correction... IT WORKS with the Quotes. The remaining issue was with my last column. There was a typo there. Should have been greater than and then less than. I had em backwards. THANKS FOR THE HELP GUYS AS ALWAYS!!!

[rpeare]

try a criteria of

'60' or '61' or '63'

in each of your REOCCURCODE fields

Also, as others have said, make sure you copy the criteria in your BILLMOYR field down to the 2nd and 3rd rows as well.

[pbaldy]

Test a little and I suspect you'll find that records that meet the In() criteria in the _2 and _3 fields aren't necessarily meeting the criteria in that far right field.

[Russellh]

try a criteria of

'60' or '61' or '63'

in each of your REOCCURCODE fields

Also, as others have said, make sure you copy the criteria in your BILLMOYR field down to the 2nd and 3rd rows as well.

If I move it down will I not have to type in 6 dates?

[pbaldy]

Have you tried?