Calculating a difference between an absolute value and a sum of va

[newby]

My query needs to show time remaining from "eligible time off" and
accumulated time taken. However, rather than subtracting the total of time
taken from the eligible time off (ex. 120-80), it is running the subtraction
on each individual time off request and then adding the results (ex 120 -8,
120-8, 120-8, and coming up with 336). It is evaluating against a query the
correctly sums the time off requests. Any help? I am very new to Access and
have no familiarity with SQL.

 

[Marshall Barton]

My query needs to show time remaining from "eligible time off" and
accumulated time taken. However, rather than subtracting the total of time
taken from the eligible time off (ex. 120-80), it is running the subtraction
on each individual time off request and then adding the results (ex 120 -8,
120-8, 120-8, and coming up with 336). It is evaluating against a query the
correctly sums the time off requests. Any help? I am very new to Access and
have no familiarity with SQL.

How are you calculating the total time taken? That depends
on what your query is doing so post a Copy/Paste of the
query's SQL view would probably help clarify your question.