Calculation in query 1

[hdgirl]

Hi
i have a problem with a query i am trying to create. It is for a leave form the tables i have are Annual entitlement Previuosly taken, Present Balance,This leave & Balance. my problem is that i want the previously taken field to be 0 on the first record, then the next record would show the leave taken from the previous record and so on,as such

Entitlement Previously Taken Present Bal This Leave Bal
20 0 20 3 17
20 3 17 2 15
20 5 15 2 13

i can work out the present balance and the balance but cant get the previously taken. any help would be appreciated

CJB

 

[jksmi]

Hi Cheryl, no worries - beats working for a living

HTH, Jamie