>Hi,
>
> I have tried it. But I get UNION cannot in subquery. (I used UNION in my 1st stage result)
>Any idea?
>
I can't see what you're doing!!! Can't you build a query with your 1st stage result and then use this for your report? What is your table structure?
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com