Union Query Not working 1

[awarmplace]

I am trying to run a Union Query that will pull multiple Queries together from Multiple Access Databases. The fields in each access query are the same for all of the queries I am trying to pull together. I am getting an error message stating the the second query path. I have checked the path and it is valid. Can someone verify that the SQL Code I am using looks ok?

Below is the SQL I am using:

SELECT * FROM [Qry_GrossRevenue_CPC-AP-Totals]

IN 'A:\BAM!\Databases\Transaction Databases\Patti Reports\GRP-4-GrossRevenue.mdb';

UNION ALL SELECT * FROM [Qry_GrossRevenue_CPC-AP-Totals]

IN 'A:\BAM!\Databases\Transaction Databases\Patti Reports\GRP-5-GrossRevenue.mdb';

 

[jrbarnett]

take the semi colon off the end of the first IN statement.

John