Concatenate

[shank]

I'm using Concatenate to assemble data in the query grid.
Problem: Results will only show 255 characters.
How can I display all characters which may be 1,000

thanks

 

[Guest]

Text fields in tables can only hold 255.
To show a concatenation of text fields in a query, use the follow:
NewField: [Field1] & [Field2] & ...... & [Fieldn]
in an adjacent field you can have the following:
COUNT: len([newfield])
to show you how many chars you have

HTH
Hafeez Esmail

 

[shank]

I'm using the following function...

Ts: Concatenate("SELECT Field1 & ') ' & Field2 & ' - ' & Field3 FROM Final
WHERE [Final].[DNo] =" & Final.DNo & " ORDER BY [Final].[TNo]")

And the results are no longer than 255 characters.
How do I get all the characters to display?
thanks

Text fields in tables can only hold 255.
To show a concatenation of text fields in a query, use the follow:
NewField: [Field1] & [Field2] & ...... & [Fieldn]
in an adjacent field you can have the following:
COUNT: len([newfield])
to show you how many chars you have

HTH
Hafeez Esmail

I'm using Concatenate to assemble data in the query grid.
Problem: Results will only show 255 characters.
How can I display all characters which may be 1,000

thanks

 

[shank]

Never mind!
I was using DISTINCT
fixed...
thanks

 

[Marshall Barton]

I'm using Concatenate to assemble data in the query grid.
Problem: Results will only show 255 characters.
How can I display all characters which may be 1,000

That can happen if the query has to use the result field for
something such as GROUP BY, UNION, DISTINCT, etc.

If you can't spot the reason, post the query's SQL
statement.