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.
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.
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.
I only want to output the results - Row 1 ONLY of the Emerald and Negative sheets attached.
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.
My apologies, the file is attached with formulas that generate the totals. The other numbers are downloaded from a database.
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
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.
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.