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