I've inherited a database that used to have a total field in it. I've removed the total but now find myself having to recalculate the total from existing fields in 37 places including 22 queries. Is there any way to create a function that can access the fields in the current records and return the total?
if this was on a form I could do something like:
But calling this from a query says it doesn't recognize me.
Thanks
if this was on a form I could do something like:
Code:
public function curGetTotal() as currency
curGetTotal = me.curCost + me.curPenalty + me.curForfeiture
end function
But calling this from a query says it doesn't recognize me.
Thanks