OK.
I have never used the Analyze with Excel feature in Access but I have
met a number of people in newsgroups who have had problems with it.

I always start from the Excel end and build the query in MSQuery.
The result is always good.
Would it be too difficult to rebuild the Access query in MSQuery?

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup