error 3163

[kingz2000]

Hi,

in Access 2003 I am combining several queries using 'UNION' as each query has the same columns.
When I execute the queries individually there is no problem. When I join them as following:

SELECT * FROM Aviation
union
SELECT * FROM Construction
union
SELECT * FROM [Financial Lines]
union
SELECT * FROM LIAB
union
SELECT * FROM MARINE
union
SELECT * FROM Motor
UNION
SELECT * FROM PROP;

I get the error 3163: The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data.

I can't understand this message, as my result is a query and not a table.

Thanks for any help.

Kingsley

 

[Remou]

Try this:

http://support.microsoft.com/?scid=kb;en-us;896950&spid=2509&sid=285

 

[kingz2000]

well the link unfortunately doesn't do me any good, because I don't have a Memo-Field!! I am joining multiple queries together.

 

[Remou]

Sorry, wrong link . As far as I recall, the link I wanted suggested using Union All instead of Union.

 

[kingz2000]

yes I tried that after searching in the interent, but that didn't help!

 

[Remou]

I am sorry I cannot help, I do not know what you have tried, so I do not know what to suggest.