J
Jimbo213
Using Access2003-SP2 with XP:
I have a form with 12 yes-no fields.
I'd like to build a report using a query to those 12 fields so that the
query qualifies any row where the OR condition is met.
For example:
YN01 = -1 or
YN02 = -1 or
YN03 = -1 or
....
YN12 = -1
The query builder stops at YN09 - apparently an Access limit.
In SQLView it shows the WHERE clause having 9 "or" conditions.
How can I get 12 conditions?
I have a form with 12 yes-no fields.
I'd like to build a report using a query to those 12 fields so that the
query qualifies any row where the OR condition is met.
For example:
YN01 = -1 or
YN02 = -1 or
YN03 = -1 or
....
YN12 = -1
The query builder stops at YN09 - apparently an Access limit.
In SQLView it shows the WHERE clause having 9 "or" conditions.
How can I get 12 conditions?