Formulas

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hi... i need help with the following. i have the below table
Date AHTTarget AHT Budget ProdBudget QualityBudget
2006-06-01 140 90 90 90
2006-07-01 136 90 90 90
2006-08-06 136 95 90 90

I need to run a query to calculate performance figures based on the target
set for that month...so if an employees AHT for june is 156, the formula
would be 156/140. if its for August, it would be 156/136.the targets are
input manually at the begining of each month.
Thanks for your help.
 
Nero

"are input ... each month" ... Input into what? Into the query? Into the
table? And where is the employee's AHT -- I don't see where you're getting
the "156" from.

If your table has only one entry per month, your query could select by year
and month, and use a parameter to get the target (or is it the employee
figure?)...

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/
 
Hi Jeff...

I have two tables. A target Table And an Activity table. Target table has
the set target for each month. One entry per month, this is captured via a
form into the table. The activity table stores the agents daily stats, also
captured directly into the table. I need to calculate agent efficiency based
on the formula below. Agent Actual AHT(this is from the Activity table)
devided by Target AHT, this is from the target table. 156 is just an exmple
and would be found in the Activity table(Agent Actual AHT). the query needs
to have a date parameter, so the Agent Actual Aht is averaged over a
specified period and then devided by the target AHT. The Months need to match
so that Agent Actual AHT fr June is Matched with target AHT for June and so
on.

I appologise for the lengthy explanations, I'm learning:)
 
Back
Top