By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,479 Members | 1,603 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,479 IT Pros & Developers. It's quick & easy.

IIf fun.

P: 1
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?
Oct 6 '08 #1
Share this Question
Share on Google+
1 Reply

P: 69
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.
Oct 6 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.