Results 1 to 2 of 2
  1. #1
    pdowg881 is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Apr 2015
    Posts
    14

    Renaming Datasheet totals row

    I have a form in datasheet view that has totals enabled. The totals row label is "Totals" at the left most column of the totals row. In each of my value columns I have selected "average". Is there a way to get the "totals" label to say "average"? It is confusing to the user and looks wrong to have a row labeled "Totals" when it is displaying averages. Is there a way to access this through VBA?



    Thanks.

  2. #2
    CJ_London is online now VIP
    Windows 8 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,936
    Don't believe so - it doesn't know that all columns are averages (or count etc) and could be a mixture of types.

    Only way would be to use a continuous form a put the totals/average in the footer

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 7
    Last Post: 12-04-2014, 12:47 PM
  2. Sum Specific Rows as Totals in Datasheet View
    By CementCarver in forum Forms
    Replies: 4
    Last Post: 07-31-2013, 07:31 AM
  3. Totals showing across bottom of Datasheet view
    By Laurie B. in forum Access
    Replies: 8
    Last Post: 09-14-2011, 01:47 PM
  4. Totals in Datasheet View only shows COUNT
    By nypedestrian in forum Forms
    Replies: 6
    Last Post: 08-26-2011, 08:23 AM
  5. Subform, Totals, in Datasheet view
    By eww in forum Programming
    Replies: 1
    Last Post: 09-27-2010, 10:22 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums