Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Specify list items with unlimited ANDs and ORs?

0 views
Skip to first unread message

mscertified

unread,
Jun 20, 2007, 5:54:13 PM6/20/07
to
My form has a list of items.
I need the user to be able to select multiple items and specify the
conditions using any combination of ANDs and ORs.
Has anyone come up with a good (simple for user and easy to implement for
me)way to do this?
e.g. list contains A,B,C,D,E,F
User needs to be able to specify
A and (B or C)
B or (C and D)
etc. etc.
Probably one level of parentheses will be enough.

KARL DEWEY

unread,
Jun 21, 2007, 6:44:00 PM6/21/07
to
I created a form/query that would AND or OR two textboxes based on a checkbox.
SELECT [Old-New].NewID, [Old-New].OldID
FROM [Old-New]
WHERE ((([Old-New].NewID)=[Forms]![AND-OR Form]![List2]) AND
(([Old-New].OldID)=[Forms]![AND-OR Form]![List4]) AND (([Forms]![AND-OR
Form]![check6])=0)) OR ((([Old-New].OldID)=[Forms]![AND-OR Form]![List4]) AND
(([Forms]![AND-OR Form]![check6])=-1)) OR ((([Old-New].NewID)=[Forms]![AND-OR
Form]![List2]) AND (([Forms]![AND-OR Form]![check6])=-1));
You might build on this idea.
--
KARL DEWEY
Build a little - Test a little
0 new messages