View Single Post
  #1  
Old January 7th, 2010, 08:31 PM posted to microsoft.public.access.reports
User via AccessMonster.com
external usenet poster
 
Posts: 28
Default How do I make an average on a report out of formula totals?

I've made a report titled HR Efficiency Report. This report contains the
employee name, their pay rate and all of the information needed to calculate
formulas. I have successfully created a text box titled Total Eff that
properly displays the formula =[On Std Earned]/[Total Hourly Pay]. This
report is based on a query and I would like the user to be able to run the
query based on a single employee (which I have successfully done as well).
However, I am running into a problem when I try to get an average for my
Total Eff text box. Every time I try to open it it opens an Enter Parameter
Value box and asks me for the On Std Earned and the Total Hourly Pay. I have
both of these text boxes (which also contain formulas) in the report as well.
Why am I getting this message? Is there an easier way to get an average of
numbers that have been calculated already?

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ports/201001/1