Average Error On Report

[Kevin]

I have a database were I want to track an employees average production.
My table includes the entries Associate Number, Date, Category, Goal,
Units and Hours which are entered via a form.

To display the average I created a report that calculates the average
using the formula =Sum([units]/[hours])*0.01 in the average field
located on the report.

If I have one entry in my table the report looks perfect but when I
begin adding information the formula is obviously wrong. Here is what
it looks like with more than one entry.

Associate Number Date Category Units Hours Average
0001 12/06/06 Hard Home 800 8 400%
0002 12/06/06 Soft Home 800 8 400%
0003 12/06/06 Shoes 800 8 400%
0001 12/06/06 Mens Apperal 800 8 400%

When I have just one entry in my table it looks like this...which
starts out correct.

Associate Number Date Category Units Hours Average
0001 12/06/06 Soft Home 800 8 100%


How can I track the average per entry in my table so it works correctly
on my form?

 

[Marshall Barton]

I have a database were I want to track an employees average production.
My table includes the entries Associate Number, Date, Category, Goal,
Units and Hours which are entered via a form.

To display the average I created a report that calculates the average
using the formula =Sum([units]/[hours])*0.01 in the average field
located on the report.

If I have one entry in my table the report looks perfect but when I
begin adding information the formula is obviously wrong. Here is what
it looks like with more than one entry.

Associate Number Date Category Units Hours Average
0001 12/06/06 Hard Home 800 8 400%
0002 12/06/06 Soft Home 800 8 400%
0003 12/06/06 Shoes 800 8 400%
0001 12/06/06 Mens Apperal 800 8 400%

When I have just one entry in my table it looks like this...which
starts out correct.

Associate Number Date Category Units Hours Average
0001 12/06/06 Soft Home 800 8 100%


How can I track the average per entry in my table so it works correctly
on my form?

I don't understand. The way I read your question, It seems
like you should not be using the Sum function.