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)
 
Back
Top