I am using Access 2000, The error msg I've got is :
"The operation is not allowed Inside a subquery" howevwer,
Your second suggestion worked wonderful.
I have already solved it by another elegant way:
Create a view for the complex UNION subquery and then your query is much
WHERE PolicyID in (Select PolicyID from view)
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!