Getting rid of Decimal places in a formula

[SDS100UK]

Hi

I have two concatenated fields, 1 text and 1 number.

When I put the 2 together in a third, the number bit has 2 decimal places, which I cannot seem to remove.

How do I do this?

In the Number field on its own there is no decimal places, they only appear in the concatenated field.

Hope someone can help me,

TIA

Steven

 

[IdoMillet]

Use:
---------------------------------------
{str_Field1} + ToText({num_Field},0,"&quot
---------------------------------------

Cheers,
- Ido
CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[AyJayEL]

{Field1}+totext({Field2},0)

Should do it I believe. Learn something new every day *:->*
AyJayEl

 

[AyJayEL]

SNAP Learn something new every day *:->*
AyJayEl