Is it possible to perform a calculation in a Query using If...Then...ElseIf?<br>
<br>
This is basically what I want to do<br>
<br>
Amount in Tons: If «Expr» [Unit Type] = gallons then [UnitAmount] * [WasteTypeID] / 2000 ElseIf «Expr» [Unit Type] = Pounds then «Expr» [WasteTypeID] / 2000 ElseIf...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.