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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Suppressing Decimals if .00 1

Status
Not open for further replies.

GCL2007

IS-IT--Management
Dec 11, 2007
167
US
I have a form with a Qty Shipped field on the form which is actually a Sum of Qty_Shipped for a Packing Slip item. I have run into a situation where I needed to ship decimals (.5 or .25) quantities. 99.9% of the time I ship in numbers with no decimals and I really don't want to format the field to show .00 on every line item. Is there a way I can display the decimals only when they exist, but whole number (without the .00) for the rest of the time? Thanks!
 
Hi GCL2007

Right click on the sum field and select 'Format Field', then click on 'Customize'.

In the 'Custom Style' dialogue box, click on the x2 button beside 'Decimals', enter the following formula:

Code:
If      CurrentFieldValue = INT(CurrentFieldValue)
Then    0
Else    2

Hope this helps.

Cheers
Pete
 
Pete - Thanks.. I think this will work for me! GCL2007
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top