Results 1 to 8 of 8
  1. #1
    clorodet20607 is offline Novice
    Windows 10 Access 2016
    Join Date
    Apr 2021
    Posts
    5

    Want to show Totals only in 1 row


    I have 2 queries, "qryEmerald", and "qryNegatives < 30 days". I also have a Totals query, "qryTotal Negatives 1-30 days". I am trying to show the Totals only in 1 row for each query.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    What do you mean by "in 1 row for each query"? Provide example of desired output. Use forum table builder tool on the Advanced Editor toolbar.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    clorodet20607 is offline Novice
    Windows 10 Access 2016
    Join Date
    Apr 2021
    Posts
    5
    I only want to output the results - Row 1 ONLY of the Emerald and Negative sheets attached.
    Attached Files Attached Files

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    I am more confused. I can see 8711.50 and -17981.16 sums in both files but nothing else agrees. If you want those sums output in a query then build an aggregate with appropriate grouping.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    clorodet20607 is offline Novice
    Windows 10 Access 2016
    Join Date
    Apr 2021
    Posts
    5
    My apologies, the file is attached with formulas that generate the totals. The other numbers are downloaded from a database.
    Attached Files Attached Files

  6. #6
    Join Date
    May 2018
    Location
    Living in Scotland UK
    Posts
    1,557
    Hi

    Your database file does not make any sense at all ?

    Also, the Excel file make no sense to someone who does not understand your business process.

    Can you explain in more detail?
    You can PM me if you need further help.
    Good Reading https://docs.microsoft.com/en-gb/off...on-description

  7. #7
    clorodet20607 is offline Novice
    Windows 10 Access 2016
    Join Date
    Apr 2021
    Posts
    5
    Thank you for responding June and Mike. My database contains many tables, queries, macros, etc. for the process. It is finished except for this last piece where I'm having problems showing the TOTALS ONLY row (with no detailed data for the Credits (Negatives), Emerald account, and Current accounts (Not Due). In trying to remove proprietary data, I've only included the tables and queries associated with this request.

    This is my 1st post so I really apologize for fumbling through this but if I need to include the entire database, I'll need time to sanitize it. Please advise.

  8. #8
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    If you want the data as shown in TOTALS ONLY row, then build an aggregate query or build a report and do aggregate calcs in report design. Textboxes in Report footer with calcs: =Sum(fieldname).
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Replies: 2
    Last Post: 12-18-2019, 10:40 PM
  2. I can get average etc. to show on TOTALS row but not SUM.
    By tbjmobile@gmail.com in forum Access
    Replies: 9
    Last Post: 04-22-2019, 01:05 PM
  3. Replies: 1
    Last Post: 03-06-2016, 10:35 PM
  4. Replies: 2
    Last Post: 01-08-2015, 12:41 AM
  5. Replies: 1
    Last Post: 03-15-2007, 03:38 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