J
Jerry Martin
Hello, I am having a difficulty trying to use a Weighted Average in
the Access Query Design View. I can run a simple query to group my
data and generate a simple average on the availability of a machine
(Availability). However I need to make it a weighted average that
takes into account the minutes it is scheduled to run. By hand it
would look something like this:
(Availability of Machine1) * (Minutes of Machine1)/(Combined Minutes
of all machines) + [The same expression for machine2] ... All the way
to the last machine.
The problem is I can't figure out how to get the Combined minutes for
my query and stick it into a 'Group By' Total. I have created a
separate query that can total up all Combined minutes of all machines.
It will work fine if I group all the data into just one row, but if I
use this amount and group the data into more than one row, the total
minutes is for all the machines but not just the subsets. My averages
then get all screwed up. Can anyone help? Thanks.
the Access Query Design View. I can run a simple query to group my
data and generate a simple average on the availability of a machine
(Availability). However I need to make it a weighted average that
takes into account the minutes it is scheduled to run. By hand it
would look something like this:
(Availability of Machine1) * (Minutes of Machine1)/(Combined Minutes
of all machines) + [The same expression for machine2] ... All the way
to the last machine.
The problem is I can't figure out how to get the Combined minutes for
my query and stick it into a 'Group By' Total. I have created a
separate query that can total up all Combined minutes of all machines.
It will work fine if I group all the data into just one row, but if I
use this amount and group the data into more than one row, the total
minutes is for all the machines but not just the subsets. My averages
then get all screwed up. Can anyone help? Thanks.