G
Guest
I want to link several queries together and have them display thier data all
at once for export. Each individual query works just fine, although they do
each require that a piece of data in their WHERE clauses come from a form
that will be open. The query is as follows:
SELECT * FROM qryExportEstimate2Primavera
UNION
SELECT * FROM qryPrimaveraFISI
UNION
SELECT * FROM qryPrimaveraMaterialCost
UNION SELECT * FROM qryPrimaveraOH&P;
However, whenever I try to run it, I get the error: "Syntax Error in FROM
clause."
What's the problem?
Thanks!
Dustin
at once for export. Each individual query works just fine, although they do
each require that a piece of data in their WHERE clauses come from a form
that will be open. The query is as follows:
SELECT * FROM qryExportEstimate2Primavera
UNION
SELECT * FROM qryPrimaveraFISI
UNION
SELECT * FROM qryPrimaveraMaterialCost
UNION SELECT * FROM qryPrimaveraOH&P;
However, whenever I try to run it, I get the error: "Syntax Error in FROM
clause."
What's the problem?
Thanks!
Dustin