Consolidated report for each transaction group (1 Viewer)

access2010 · Apr 9, 2018

Hello.

Could I please receive assistance in placing a consolidated report for each transaction group on page number 2 of our Ms Access 2003 report?

Thank you for your suggestions.

Nancy

pbaldy · Apr 9, 2018

Not sure what you mean by transaction group, as there's no such field. My first thought is a subreport based on a totals query that groups/sums as desired.

access2010 · Apr 10, 2018

Thank you for your question.

What our Volunteer office would like to do is have a report on page #2 that would group each of the Description Items;

As an example;
Dividend (total) $721.96
Cash_Balance (total if one or more) $709.75
Plus any others.

Total of Credits Total of Debits

Thank you for your assistance.
Nicole

Pat Hartman · Apr 10, 2018

Create a report that produces the data you want on the second page. Then add it as a subreport in the Report Footer section.

access2010 · Apr 10, 2018

Good morning and thank you for your suggestion, which works but needs a minor tune up.

How can we have the Sub Report print on page # 02?

How can I have each of the Description Item grouped and printed?
(Dividend / Cash_Balance and any other description item)

Thank you,
Linda

pbaldy · Apr 10, 2018

Like I said and Pat repeated, use a subreport. It can be based on a totals query like:

SELECT Bank_Statement_Monthly_ReportQ.Description, Sum(Bank_Statement_Monthly_ReportQ.DebitAmount) AS SumOfDebitAmount, Sum(Bank_Statement_Monthly_ReportQ.CreditAmount) AS SumOfCreditAmount
FROM Bank_Statement_Monthly_ReportQ
GROUP BY Bank_Statement_Monthly_ReportQ.Description;

and put in the report footer. You can add a page break if desired.

Pat Hartman · Apr 11, 2018

Sorry Paul. I was trying to say what you said in a slightly simplified way since Access 2010 didn't seem to understand what you said.

pbaldy · Apr 11, 2018

No worries Pat.

access2010 · Apr 13, 2018

Thank you for trying to help us, but we are not programmers and have had no luck creating your suggestion.

Regards,
Nicole

Consolidated report for each transaction group (1 Viewer)

access2010

Registered User.

Attachments

pbaldy

Wino Moderator

access2010

Registered User.

Pat Hartman

Super Moderator

access2010

Registered User.

Attachments

pbaldy

Wino Moderator

Pat Hartman

Super Moderator

pbaldy

Wino Moderator

access2010

Registered User.

Similar threads

Users who are viewing this thread