Take your paragraph and apply
If...Then
ElseIf...Then
elseIf...Then
End if
Bart
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of
dwbridgeman
Sent: Thursday, May 05, 2005 11:27 AM
To: [email protected]
Subject: [vbhelp] Decimals
FEES = Str(SALES_FEE)
where sales_fee is nnn.dd and currency data type
fees is a string
if sales fee is nnn.dd with dd being > 0 then fees = nnn.dd
if sales fee is nnn.d0 then fees = nnn.d not nnn.d0
if sales fee is nnn.00 then fees = nnn not nnn.00
The conversion to a string losses the trailing zeros and I need the
value with zeros in string format. I need the .00 precision.
So, in summary, HELP, please.
'// =======================================================
Rules : http://ReliableAnswers.com/List/Rules.asp
Home : http://groups.yahoo.com/group/vbHelp/
=======================================================
Post : [email protected]
Join : [EMAIL PROTECTED]
Leave : [EMAIL PROTECTED]
'// =======================================================
Yahoo! Groups Links
'// =======================================================
Rules : http://ReliableAnswers.com/List/Rules.asp
Home : http://groups.yahoo.com/group/vbHelp/
=======================================================
Post : [email protected]
Join : [EMAIL PROTECTED]
Leave : [EMAIL PROTECTED]
'// =======================================================
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/vbhelp/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
