concatenate function max characters?

[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

 

[Joseph Meehan]

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.

 

[Guest]

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.

 

[Joseph Meehan]

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.

 

[Duane Hookom]

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.