Results 1 to 4 of 4
  1. 05-24-2016, 05:53 AM #1
    caniread
    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
    Reply With Quote Reply With Quote
  2. 05-24-2016, 08:22 AM #2
    InsuranceGuy
    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
    Reply With Quote Reply With Quote
  3. 05-25-2016, 04:30 AM #3
    caniread
    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?
    Reply With Quote Reply With Quote
  4. 05-25-2016, 05:02 AM #4
    Bob Fitz's Avatar
    Bob Fitz
    Bob Fitz is offline Access Developer
    Windows 7 32bit Access 2013
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,614
    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
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Create report to total the number of each product order and total cost for that product in a year
    By GodivaGirl in forum Reports
    Replies: 3
    Last Post: 01-18-2015, 06:05 PM
  2. Please help on how to calculate total down time and total production run time from table????
    By Alphix in forum Queries
    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
  •  

Forum Rules

Other Forums: Microsoft Office Forums