G
Guest
I'm trying to write a query and I can't seem to nail down how it should
go. I have a list that consists of the following information.
Name Red Green Blue Yellow
Jim Yes No Yes No
Bill Yes Yes Yes No
Frank No Yes Yes No
And I want to be able to select the records that have two out four, or
maybe three out of four colors without regard as to which color it really is.
I know how to blue blue's and green's with red's etc... but not 3 out of 4.
Can someone help?
go. I have a list that consists of the following information.
Name Red Green Blue Yellow
Jim Yes No Yes No
Bill Yes Yes Yes No
Frank No Yes Yes No
And I want to be able to select the records that have two out four, or
maybe three out of four colors without regard as to which color it really is.
I know how to blue blue's and green's with red's etc... but not 3 out of 4.
Can someone help?