Calculations during record import

[erol]

I am importing several fields from an Access db.

Most of these are calcuated fields. So I created the queries in Access and I do not have to worry about the calculations in FM.

Issue:

However, there is one calculation that cannot be performed in a single query.

Question:

What is the best way of performing calculations on the fly, during a script that contains several import record steps?.

Is it possible to execute an import returning a value, and to store that value in a "memory variable" or an array to be used in a calculation?

I appreciate your help.

(I am using FM 5.5)

Thank you

Erol