Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to add a total Section to a report 1

Status
Not open for further replies.
psperry2

psperry2

Programmer
Nov 7, 2007
141
US
I have a report that lists Name, startdate, enddate, elapsed days. I need a new section on the report where I can show the average of the Elapsed_days. I currently have a Page Header, detail and page footer section.
 
Sort by date Sort by votes
I now have a total section, but I am not sure how to get an average for the Elapsed_Days column.
 
Upvote 0 Downvote
I have got the SUM(Elapsed_Days)

What I need now is to count the number of records on the report and divide the SUM by the count to get the average.

How can I get the count?
 
Upvote 0 Downvote
I answered my own question, Someone give me a STAR!

=Sum([Elapsed_Days])/Count([Elapsed_Days])
 
Upvote 0 Downvote
there you go...


Ian Mayor (UK)
Program Error
If people say I have bad breath, then why do they continue to ask me questions and expect me to answer them?
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

SamuelR
  • Locked
  • Question
Dlookup in a report
Replies
13
Views
298
dhookom
dhookom
breezett93
  • Locked
  • Question
Report often takes multiple minutes to load, lots of formatting time between pages
Replies
5
Views
269
dhookom
dhookom
FancyPrairie
  • Locked
  • Question
How to Format a date on a report
Replies
1
Views
170
sxschech
sxschech
EwaFAMA
  • Locked
  • Question
ACCESS - Adding image from URL to the report 1
Replies
11
Views
888
EwaFAMA
EwaFAMA
caykamanj1966
  • Locked
  • Question
Open Report based on selection from a pull-down menu 1
Replies
12
Views
448
caykamanj1966
caykamanj1966

Part and Inventory Search

Sponsor

Back
Top