Trim function

[Guest]

I have a report in access. I used the "trim" function to concatenate text and
some field names. Some fields are in format of number with decimals. I want
those fields shown formatted on the report, but I need a function to format
such field within the concatenation. Can somebody know what function to use
and how to use it?

 

[Ken Snell [MVP]]

The Trim function does not perform concatenations.... it strips leading and
trailing blank spaces.

It's not clear what you're doing, but perhaps the Format function will work
for your needs? Post back if you would like more information; the function
is discussed in the Help files.

 

[Guest]

Thanks Ken for your help.

The Trim function does not perform concatenations.... it strips leading and
trailing blank spaces.

It's not clear what you're doing, but perhaps the Format function will work
for your needs? Post back if you would like more information; the function
is discussed in the Help files.