Try to create a single query that returns all the data you want. It
could be that the correct use of Criteria will achieve it. It could be
that you need to use a Union Query. Or something else.
If you need more explicit help with this, please post back with details,
explaining the data you want to export and which table(s) it comes from.
The SQL view of the queries would also help us to understand what you
are trying to achieve. Thanks.
Steve Schapel, Microsoft Access MVP