recursion in Access?

[DB88]

Got it to work!!!!!! I have one Query, InventoryQuery whose results are the field YearKey and Inv (inventory calculated using recursion)

Inv:IIF([Procurement]![YearKey] = [StartYear]; [Procurement]![Acq]; [Procurement]![Acq] + [AttritionRate]*DLookUp("[Inv]", "InventoryQuery", "[Procurement]![YearKey]="&[Procurement]![YearKey]-1))

[ItsMe]

Why the IIF? Is that an expression for an alias within your query?

[DB88]

IIF is an if/else statement. In recursion you need a base case/termination case. So, I say "if the year is the first year of the program then inventory is just that year's acquisition, else inventory is that year's acquisition + previous year's inventory*attrition"

The expression in the IIF statement asks weither the record is my base case

Does that answer your question?

[ItsMe]

Yes it does, thank you. Glad you were able to get it all in one expression. Nice