Saving query causes CTD

[Steve]

I'm trying to create a SQL query that combines some fields
together into one big field. When I execute it, it
appears to work fine, but when I try to save it, I crash
to desktop. Does anyone have any ideas? Here is the text
of the query:

SELECT tblCountofPartCovTrailer.xRecType &
tblCountofPartCovTrailer.ControlNum &
tblCountofPartCovTrailer.Filler1 &
tblCountofPartCovTrailer.Filler2 &
tblCountofPartCovTrailer.CountOfRecType &
tblCountofPartCovTrailer.Filler3 &
tblCountofPartCovTrailer.Filler4 &
tblCountofPartCovTrailer.Filler5 &
tblCountofPartCovTrailer.Filler6 &
tblCountofPartCovTrailer.CountOfRecType1 &
tblCountofPartCovTrailer.Filler7 &
tblCountofPartCovTrailer.Filler8 &
tblCountofPartCovTrailer.Filler9 &
tblCountofPartCovTrailer.Filler10 AS PartCovTrailerRecord
FROM tblCountofPartCovTrailer;

 

[Steve]

I'm really stuck on this. Does anyone have any ideas at
all?

 

[Tom Ellison]

OK, I'll take a whack.

You are probably using the Jet database engine, right? You have appended a
lot of stuff into a very long string. I don't know how long this string
might have become, or whether it has exceeded some limit. But, you say it
runs, you just can't save it.

You might make sure you have the latest version of Jet. I no longer use
Jet, and I don't know what version that is, but that would be obvious when
choosing a download. You can get this free.

Another option may depend for what you are using this query, and why you are
appending a lot of columns into one. Please explain and perhaps someone can
give you some options.