I have created a microsoft access database that deals with the amount of leave an individual takes.
I want to be able to add up the amount of leave a person takes eg. John Mark takes a day on May 19th 06 and he takes 2 days from May 24th -25th 06 and take on in June 8th 06. These days are entered in different time period.
I have fields where I entered the amount of days taken, it looks like this
NAME DAY AMOUNT
John Mark May 19th 06 1
John Mark May 24th -25th 06 2
John Mark June 8th 06 1
So I want to be able to get the total amout of leave taken by John Mark how do I go about doing this?