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

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.

newby wrote:

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.

--
Marsh
MVP [MS Access]