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

Multiply Macro for final result

Status
Not open for further replies.

christimess

Programmer
May 26, 2004
33
0
0
US
I have created the following macro:

Sub udr5()
If (Field$("CombineYear")) = "Under 15" Then
X = (Field$("AccumNYTDinOne"))
End if
DerivedField str$(X)
End Sub

Is there a way that within the above macro I can add a line to say something like
X = (Field$("AccumNYTDinOne"))*.04
(but of course have it work)

Or can another derived field or macro be made to say to take the above macro and times it by .04?
Thanks!
 
Just a guess..

Try making it a "Value" instead of a string...

x = Val((Field$("AccumNYTDinOne")))*.04

HTH,
Steve
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top