Union Query

[jo15765]

I know you can do this, but for the life of me can't recall how...
I need to run one query in my current database, and another query in a different database.

How can I use a UNION ALL to do this?

[drexasaurus]

Are you trying to combine the results of the queries? The easiest way I can think of would be to create a linked table to one of the outside databases, THEN Union them together. You can also refer to the filename of another Access database in your query, but I haven't tested it out myself. Tried to find the details for you, and this was the first thread I found: http://bytes.com/topic/access/answer...ccess-database

The example from the link that demonstrates what I'm talking about is this:

1. SELECT [RemoteQueryname].* FROM [RemoteQueryname] IN 'C:\RemoteDatabase.mdb'