Hi,

I am developing an Access database to handle an Excel-built algorithm. That is, the calculations to be executed by queries are built in Excel. I have now ecountered the problem of a calculation where the field I want to construct using a query depends on itself in other records.

I have attatched the Excel file containing parts of the algorithm, and the problem arises in two variants, namely the calculations in rows 36 and 40.

I truly hope that someone can help with a workaround for this problem.

Thanks in advance!