IIf fun.

[tioguille]

I need to create a table that reflects relationship between items. I have a set of 40 items, each item ranges from 0 to 9. I need to create rules regarding those different items. If item 1 is X and item 2 is Y then return OK or Wrong.
How do I do this?
Thanks.

[youmike]

Hi, You don't say what is the impact of the other 38 items.

If you want a series of ne records in a single table based on a range of criteria, I think you could achieve what you want by creating one "Make Table" query using one set of criteria and then a whole lot of "Append" queries to deal with all the other criteria. Each query would need to include an extra field which would use iif to set True/False values for each created record.

Having said all that, in my experience this sort of thing is usually much more easily achieved via VBA, but you'd need to post a bit more detail about your data and the desired end result for me to be sure that this is apprporiate advice. Another advantage of the VBA route is that you could have successive test on each input record each of which creates an appropriate output and this might run more quickly than the query approach, because it could be designed in such a way that it could all be done without user intervention.