"Marshall Barton" wrote in message
...

PMFJI, but I am concerned that you do not have a clear
picture of the query. You said,:
"the WHERE statement is quite complex
and uses aggregate functions",
BUT, AFAIK, a WHERE clause can not contain aggregate
functions. That is the province of the HAVING clause.
Getting mixed up on which is which can cause the query to
produce an unexpected result.


I assumed he meant *domain* aggregate functions, such as DLookup -- although
I could conceive of having an aggregate subquery.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)