Help in Access 97 states:

-------------

Unions not allowed in a subquery. (Error 3361)

You can't use a UNION operation in a subquery expression. To use a union query in a subquery, first create the union query and save it as a named query. Then include the name of the saved query in your subquery expression.

-------------

What is the syntax for calling a saved query in another query?

When I try:

SELECT *
FROM table
WHERE column IN
(
saved_query
);

it asks me to enter the parameter value for 'saved_query'.

How do I make it recognise that 'saved_query' is a saved query?

Just a guess but try:

SELECT *
FROM table
WHERE column IN
(Select * saved_query
);

D'oh!

Easy isn't it?