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.
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), " ", ""
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.