Trim function

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

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?
 
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.
 
Thanks Ken for your help.

Ken Snell said:
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.
Click to expand...
 
Back
Top