Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Calculate a running total based on the value of two colums
Hello GormCd Many thanks for your assistance. I tried what you suggested. It worked but it subtracted the Holidays Taken was subtracted from Holiday Entitlement for each instance of a holiday taken. (If what I am saying makes any sense).Whats needed is for a query which adds up all the holiday...- caomhim
- Post #5
- Forum: Microsoft: Access Other topics
-
Calculate a running total based on the value of two colums
Many thanks JPMontreal. I tried out the first query but couldn't remember how to nest the second query. Below you'll see the nested query I wrote, but could not get it to run. SELECT Absence.AbEmpno, Sum(Absence.Duration) AS SumOfDuration FROM Absence GROUP BY Absence.AbEmpno; (SELECT...- caomhim
- Post #3
- Forum: Microsoft: Access Other topics
-
Calculate a running total based on the value of two colums
I hope the title makes sense. I need to know how to subtract the value of one row and column from another. I have a Access db with a table listing of employee holiday entitlement. A record of how many days holidays taken is kept in another table. The two tables are related by employee ID. How...- caomhim
- Thread
- Replies: 4
- Forum: Microsoft: Access Other topics
