I want to call a function from a report and not have to worry about putting any part of the calculation in the query like I always do. It takes too much time. I want to simply put the USDEquivFX in the name of the report and it calculates.
I have a global function:
Function USDEquivFX(lngID As Long, dblAmount As Double, dblRate As Double) As Double
If lngID = 1 Then
USDEquivFX = dblAmount
USDEquivFX = dblAmount * dblRate
Isnt there some way to use the Function calculation only (like USDEquivFX..FX is for Function) and not have to put *any* components of the calculation in the query design? I have many reports that need I have to repeat with this calculation. I only want to calculate in the function and be done with it and be able to call it anywhere.