Results 1 to 7 of 7
  1. 06-25-2016, 03:13 AM #1
    M_vyncci
    M_vyncci is offline Novice
    Windows 10 Access 2016
    Join Date
    Jun 2016
    Posts
    8

    Average of Calculated Fields

    I have the months of Jan to Dec in calculated fields, percentage format. How to get the average of these fields?
    Reply With Quote Reply With Quote
  2. 06-25-2016, 03:16 AM #2
    CJ_London
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,845
    just a wild guess - use a group by query and the average option?
    Reply With Quote Reply With Quote
  3. 06-25-2016, 03:21 AM #3
    M_vyncci
    M_vyncci is offline Novice
    Windows 10 Access 2016
    Join Date
    Jun 2016
    Posts
    8
    I have these fields in a footer with IIf formula. Not certain on how to do it.
    Reply With Quote Reply With Quote
  4. 06-25-2016, 03:29 AM #4
    M_vyncci
    M_vyncci is offline Novice
    Windows 10 Access 2016
    Join Date
    Jun 2016
    Posts
    8
    Additional info.
    The fields are:
    - located in a footer (group & total)
    - percent format
    - calculated
    - using IIf formula
    Reply With Quote Reply With Quote
  5. 06-25-2016, 03:36 AM #5
    CJ_London
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,845
    add the controls and divide by the number of controls e.g.

    =([ctrl1]+[ctrl2]+[ctrl3])/3
    Reply With Quote Reply With Quote
  6. 06-25-2016, 04:04 AM #6
    M_vyncci
    M_vyncci is offline Novice
    Windows 10 Access 2016
    Join Date
    Jun 2016
    Posts
    8
    Should I enclose each controls in quotes as it is prompting the Enter Parameter Value dialox box?
    Reply With Quote Reply With Quote
  7. 06-25-2016, 04:30 AM #7
    CJ_London
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,845
    don't know how you are trying to do this, so cannot comment - suggest follow your other thread
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Calculated Control in Group Footer - modified average calculation
    By jcanady in forum Reports
    Replies: 5
    Last Post: 01-04-2014, 02:29 PM
  2. Creating Calculated Fields based on Calculated Fields
    By athyeh in forum Reports
    Replies: 12
    Last Post: 10-01-2013, 12:59 PM
  3. how to use a calculated field to get the average of 4 text fields
    By jbp in forum Access
    Replies: 4
    Last Post: 09-02-2013, 03:00 PM
  4. Average Data In A Single Month Using Calculated Control
    By AprilM in forum Reports
    Replies: 6
    Last Post: 10-17-2012, 03:01 PM
  5. How to average two fields row by row and not the overall column average??
    By jc1234 in forum Access
    Replies: 13
    Last Post: 05-28-2010, 11:57 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Other Forums: Microsoft Office Forums