Results 1 to 4 of 4
  1. #1
    caniread is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2015
    Posts
    86

    Total Row

    Is there a way to show on a report the total row in a query?


    Click image for larger version. 

Name:	querytotalrow.PNG 
Views:	11 
Size:	6.0 KB 
ID:	24715

  2. #2
    InsuranceGuy is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Aug 2015
    Location
    Colorado
    Posts
    126
    Quote Originally Posted by caniread View Post
    Is there a way to show on a report the total row in a query?
    Click image for larger version. 

Name:	querytotalrow.PNG 
Views:	11 
Size:	6.0 KB 
ID:	24715
    Basic google searches provide impressive results.

    https://www.google.com/search?q=ms+a...tals+on+groups

  3. #3
    caniread is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2015
    Posts
    86
    What I want is to grab the number directly from the totals row in the query. I googled it but I am thinking it isn't possible. Is it only in the query datasheet view only and you cannot tell the report to grab it from there?

  4. #4
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 7 32bit Access 2013
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,530
    Have you tried creating a text box and using the Sum() function as the Control Source
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

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

Similar Threads

  1. Replies: 3
    Last Post: 01-18-2015, 06:05 PM
  2. Replies: 4
    Last Post: 10-10-2014, 02:39 PM
  3. Total for Row
    By kwooten in forum Reports
    Replies: 7
    Last Post: 08-31-2011, 01:51 PM
  4. Sub-total Help
    By DJohns in forum Reports
    Replies: 2
    Last Post: 08-18-2011, 11:57 AM
  5. Total's Box
    By Bike in forum Forms
    Replies: 1
    Last Post: 03-31-2011, 12:15 PM

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