Calculate Average In Report?

[Kevin]

I am trying to create a DB that calculates employee production averages
on a report. My table which is called 't_production' includes the
following fields:

ID, Date, Category, Goal, Units, Hours

Information is entered into this table via a form called
'f_production'.

I have then created a report called 'r_production' which includes the
following fields:

ID, Date, Category, Goal, Units, Hours, Average

In the Average field I've experimented with various formulas however
my data always comes back incorrect. To calculate my average I'm
simply taking (Units/Hours)*10.
For example:

ID Date Category Goal Units Hours Average
0001 12/05/06 Hard Home 90 80 8 100

(80 Units/8Hours)*10= 100%

When I begin to add multiple records the data seems to get lumped
together into one sum and the averages do not correspond. For Example:

ID Date Category Goal Units Hours Average
0001 12/05/06 Hard Home 100 800 8 135
0001 12/05/06 Shoes 65 550 6 135
0002 12/05/06 Soft Home 75 780 8 135
0003 12/05/06 Hard Home 95 1000 4 135

Can someone point me in the right direction? Is there a formula that I
can include in the Average field on my report that will fix this? Am I
going about this all wrong? Should I be calculating the average within
my table first? If so, how do I do that?

 

[Brian]

is your report based on a query? I would set up a query, and have it
be based on the one table, as well as create a column named Average.
The formula for this column should be:

Average: [Units]/[Hours]

Set the format of this field to Percent and it should work.