Try surrounding TEXT with brackets. I suspect that TEXT may be a reserved
word and could be causing the problem.
SELECT [Collections88].CUSTNMBR
, [Collections88].[TEXT]
, [Collections88].TEXT2
FROM [Collections88];
UNION ALL
SELECT [KevinCollections99].CUSTNMBR, [KevinCollections99].[TEXT],
[KevinCollections99].TEXT2
FROM [KevinCollections99];
Note that your table in the first query is Collections88 but you refer to
KevenCollections88 as the tablename in the SELECT clause.
You do similar naming errors in the second query
--
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
..