concatenate function max characters?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I'm using Duan Hookom's concatenate function in a query to concatenate the
value of a certain column. This works fine, however only up to a certain
amount of characters, 255.

What can I do to either enlarge this amount or concatenate only a max amount
of records, like 20, and then concatenate the next 20 records in a new record
in the query or something?

Thanks
 
Mark said:
Hi,

I'm using Duan Hookom's concatenate function in a query to
concatenate the value of a certain column. This works fine, however
only up to a certain amount of characters, 255.

What can I do to either enlarge this amount or concatenate only a max
amount of records, like 20, and then concatenate the next 20 records
in a new record in the query or something?

Thanks

I am only guessing here, but text fields are limited to 255 characters.
Memo fields are larger.
 
Thanks Joseph.

I was initially not storing the value, just running the function in a query
as an expression. Those are limited to 255. Now I'm storing it in a memo
field indeed, using that function. Works fine.
 
Mark said:
Thanks Joseph.

I was initially not storing the value, just running the function in a
query as an expression. Those are limited to 255. Now I'm storing it
in a memo field indeed, using that function. Works fine.

I'm glad it worked for you.
 
The concatenate function will return many more than 255 characters. If you
are using the function in a query, your query syntax may limit the number of
characters.
 
Back
Top