Field formatting in concatenation 1

[LeBlatt]

The formula "CMD" & Reservation.Id outputs "CMD1 234.00", but I want it to display "CMD1234". Format doent seem to work. the Id field is an integer in the database.
Anyone knows how to proceed ? Thanks in advance.

 

[rosemaryl]

Dear Leblatt,

Try:

"CMD" & Totext(Reservation.Id,00)

HTH,

ro Rosemary Lieberman
rosemary@microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

 

[LeBlatt]

This works great. I was looking for some 'format' function.
You saved me from using :
Replace ("CMD" & Left(ToText ({Reservation.Id_Document}), Length (ToText ({Reservation.Id_Document}))-3), " ", "&quot