More than 255 char in queries

  • Thread starter Thread starter sigge
  • Start date Start date
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
 
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.
 
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

FIeld with more than 255 char on report 0
Footer more than 255 char 1
Alter Table pads spaces to 255 characters 5
Truncated Excel 255 chars 3
Problem with memo field in query 3
Memo Field is truncating to 255 Chars 6
SQL string longer than 255 characters 4
Using Group by:Last in Query 1

Back
Top