G Guest Oct 28, 2007 #1 Can't seem to get this to work can someone please help Expr1:Int(CDec( [DETAIL_LINE_AMT]*0.0675+ 0.005) * 100 / 100)
Can't seem to get this to work can someone please help Expr1:Int(CDec( [DETAIL_LINE_AMT]*0.0675+ 0.005) * 100 / 100)
M Marshall Barton Oct 28, 2007 #2 Mike said: Can't seem to get this to work can someone please help Expr1:Int(CDec( [DETAIL_LINE_AMT]*0.0675+ 0.005) * 100 / 100) Click to expand... Will this do what you want? Expr1:Int([DETAIL_LINE_AMT]*0.0675+0.005 * 100) / 100
Mike said: Can't seem to get this to work can someone please help Expr1:Int(CDec( [DETAIL_LINE_AMT]*0.0675+ 0.005) * 100 / 100) Click to expand... Will this do what you want? Expr1:Int([DETAIL_LINE_AMT]*0.0675+0.005 * 100) / 100
J Jeff Boyce Oct 28, 2007 #3 Mike "...can't ... get this to work ..." could mean a lot of things. Does it run but return incorrect values? Does it fail to run and gives an error message (it would be helpful to know what that message says)? Does it cause your PC to begin smoking? A bit more specific description will probably lead to more specific suggestions. (what are you expecting to have happen if your [DETAIL_LINE_AMT] is Null or empty?) -- Regards Jeff Boyce www.InformationFutures.net Microsoft Office/Access MVP Microsoft IT Academy Program Mentor http://microsoftitacademy.com/
Mike "...can't ... get this to work ..." could mean a lot of things. Does it run but return incorrect values? Does it fail to run and gives an error message (it would be helpful to know what that message says)? Does it cause your PC to begin smoking? A bit more specific description will probably lead to more specific suggestions. (what are you expecting to have happen if your [DETAIL_LINE_AMT] is Null or empty?) -- Regards Jeff Boyce www.InformationFutures.net Microsoft Office/Access MVP Microsoft IT Academy Program Mentor http://microsoftitacademy.com/
