Reference last result

[007]

I am writing a query to calculate a running value, looking at the result of the line above and adjusting the running value in relation to new criteria. Make sense ?

For example

I have a number of dates which each have a value (a) against them dependant on the value in (a) I want to reward it in different ways and store the result in (b), I then want to look at (b) in the result of the above line in acessing how I will reward the next record.

Basically I want to read the value of the result of the line above when calculating the next line ? So it is basically cumulative through the query.

ps just found this forum so sorry for postiong a question first but any guidance appreciated.

 

[lawsonium]

I would say this is best achieved using VBA or similar script. If I have read your question correctly it doesn't seem like something you would naturally do in SQL. Purely because it is iterative and recursive.

Do you see what I mean?

Matt

 

[007]

I would say this is best achieved using VBA or similar script. If I have read your question correctly it doesn't seem like something you would naturally do in SQL. Purely because it is iterative and recursive.

Do you see what I mean?

Matt

I did consider VBA Matt but would have thought it within the realms of a query but I take it I am wrong...

Whilst I could not have come up with such... Iterative and Recursive are good words to describe exactly what it is.

Would have just been far easier in a query as I am laying it out on a Form and have differing sized groups of records to analyse