Access 97

B

Bruce

I Have a program in Access 97 in which is an Expression in the query that is
for Cost: [Hourly Rate]*[Output]. That's fine but when I create a Report
from the query which includes the above I can't seem to get an average i.e.
=Avg {[Cost]}in the Detail Footer which is Grouped on each Employee. It
comes up "Overflow" error
Can anyone help?


Best Wishes
Bruce
( Illegitimi non carborundum est )
 
D

Douglas J. Steele

To calculate an average, Access needs to get the total of all values first.
It sounds as though your total may be too large to fit in whatever data type
is involved.
 
Top