[Access VBA Central] Re: Query Quandary: Calculate field based on previsou row data

[emanday9]

I think you'll find the DLookup function will provide the solution.