More than 255 char in queries

S

sigge

Hello!

Anyone how can help me with a 255 char problem. I've got
a query that generates a string with more than 255 chars.
I cant find a way to change the output field to a note
that handels 65 000 chars. Probebly is ther an SQL
command for this?

/sigge
 
D

Duane Hookom

You probably have words like "DISTINCT" or "GROUP BY" in your query. Remove
them. If this doesn't work, paste your sql in a reply.
 
M

Myles

I've having a similar problem (also posted) - I think the
root of the problem is that access SQL doesn't seem to
recognise varchar as a datatype - if I enter this into
the SQL, or change a parameter type to memo Access
reverts it to Text (255)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Truncated Excel 255 chars 3
Bug report: Table fields of type MEMO are chunked 'cause of CONSTR 3
Memo Field is truncating to 255 Chars 6
Truncating a CLOB field to 255 Chars 0
What Kind Of Query Can I use? 6
UDF Can't return more than 255 chars??? 3
Categories and textlength of 255 chars 0
Will Word mailmerge more than 255 characters from an Excel file? 4

Top