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
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