union qry problem

[christine t.]

I get an unmatched column error returned on my union qry. The 2 queries in
the union qry have the same field headings and data type in the same order.
One query has 2007 data and the other 2008 data. Any solution to try would
be great - thx.

 

[John Spencer]

Post the SQL of your query. It is impossible to trouble-shoot what we
cannot see.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
'====================================================

 

[christine t.]

here's the SQL:

Select * from 2007 qry
Union
Select * from 2008 qry

 

[Duane Hookom]

If you create objects with spaces in the names, you gotta pay the [] price.
Try:
Select * from [2007 qry]
Union
Select * from [2008 qry];

 

[christine t.]

thx for the advice, I'll give it a try.
--
c.t.

If you create objects with spaces in the names, you gotta pay the [] price.
Try:
Select * from [2007 qry]
Union
Select * from [2008 qry];

--
Duane Hookom
Microsoft Access MVP

here's the SQL:

Select * from 2007 qry
Union
Select * from 2008 qry