Help with formula

M

Mike

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

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

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/
 
Top