I have an update query that calls a function to calculate the value assigned in the set clause, but the calculation uses the values from 30 fields, which can't all be passed in one call, so I'm performing the calculation in two update statements.
Set F1 = Func( F2, F3, ... F30 )
Where F31 = some condition
Is there a way to implicitly or explicitly pass a row cursor to the function so that it can look at all of the fields it needs to in one call? I tried passing in the record's primary key value, and then having the function open it's own recordset on the same table and fetching the row with that key value, but that was much too slow. I need to use the regular query tool, i.e., can't run the query in vb
, and I'm using Access 2000.