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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Grand Average Calculation on Report

Status
Not open for further replies.
cav

cav

MIS
Feb 3, 2000
49
US
I have 4 Fields from a query in a report.
[Name][#Contacts][#NonProductiveContacts] [ContactRate]
All the fields come from a query. Contact Rate is a Query calculation. In Name footer =Sum[#Contacts]and =Sum[#NonProductiveContacts] for totals. I need an average of all the rates in this footer and a grand average in the Report footer. The calculation I am trying is =(Sum([#Contacts]))/((Sum[#Contacts])+(Sum([#NonProductiveContacts]))). Please help.
 
Status
Not open for further replies.

Similar threads

BallunarCrew
  • Question
ODBC Driver Struggles on new computers
Replies
2
Views
268
BallunarCrew
BallunarCrew
lameid
  • Locked
  • Question
Execution Slowing on iterative generation of PDF's
Replies
3
Views
784
lameid
lameid
Bennie47250
  • Locked
  • Question
Report Crashes
Replies
2
Views
329
kray4660
kray4660
renigar
  • Locked
  • Question
Access 365: Search LastName in one table to put EmployeeID in another
Replies
8
Views
938
renigar
renigar
Moss100
  • Locked
  • Question
Create a Report from a query and then personalise the report for each client - possible?
Replies
2
Views
332
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top