Example of getting effective dated rows and doing math on some fields??

[porkins]

I want to put a calculated value into my report that is based off the addition of two fields from the most recent effective dated rows in two seperate tables. What would this code look like? Should I create a temp table to hold the variable in order to put it in the report?

Thanks,
Dan

 

[Calvin]

you don't need a temp table.

just use DLookup Method to retrieve your values from the two tables and perform your math on the fly through an action event like OnLoad or OnCurrent.
If its simple enough it's possible to put it in the property sheet of the control and there is no need for any behind the scenes code.