Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Format concatenated number fields

Status
Not open for further replies.

KBChristy

IS-IT--Management
Sep 3, 2002
32
GB
I want to concatenate 2 number fields as follows;

field 1 = 4563
field 2 = 4

to 4563 / 4

However, when I do this, I get the following;
4,563.00 / 4.00.

How can I remove the 1,000's comma and the decimal places please so that it shows as 4563 / 4?

Thanks a lot.
 
Try this:

totext({NumberField1},0,"")+"/"+totext({NumberField2},0,"") Software Sales, Training and Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top