Combining Text Fields - Please Help

[Guest]

I have 48 fields each with 8 chars in each field. I need to combine into just
one field. I am using the [field1] & [field2] etc. however I can only combine
upto 255 chars at a time, any suggestions?

 

[Allen Browne]

In a query, you should be able to concatenate more than 255 characters
together, unless you are asking Access to perform some kind of operation on
the result.

The reasons why it might be chopped off at 255 characters are the same
reasons a memo field gets trunctated:
Truncation of Memo fields
at:
http://allenbrowne.com/ser-63.html

There is also a bug in Access if you use a concatenated field in a
recordset:
Concatenated fields yield garbage in recordset
at:
http://allenbrowne.com/bug-16.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

message
news:[email protected]...

 

[Guest]

hmm, thats a lot of fields. Is that in one table or are you using a query?

 

[Guest]

hmm, thats a lot of fields. Is that in one table or are you using a query?

I am using a query to concatenate but is sourced from an SQL database table

I have 48 fields each with 8 chars in each field. I need to combine into just
one field. I am using the [field1] & [field2] etc. however I can only combine
upto 255 chars at a time, any suggestions?