Concatenate

S

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
 
H

Hafeez Esmail

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
 
S

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

Hafeez Esmail said:
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 said:
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
Click to expand...
Click to expand...
 
M

Marshall Barton

shank said:
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
Click to expand...


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.
 
Top