J
JoeWM
I have an autonumber key field in a query that I want to
filter based on a field in the current record on a form.
If the field on the form has one number in it, such
as "1550", the query filters appropriately. But if the
field has two numbers separated by OR, such as "1550 OR
2385", the query finds no records. If I enter "1550 OR
2385" directly into the query criteria manually, it
filters appropriately. Help, please.
filter based on a field in the current record on a form.
If the field on the form has one number in it, such
as "1550", the query filters appropriately. But if the
field has two numbers separated by OR, such as "1550 OR
2385", the query finds no records. If I enter "1550 OR
2385" directly into the query criteria manually, it
filters appropriately. Help, please.