Jump to content

Sub-Summary and Grand-Summary with two files?


LarryLogic

This topic is 7569 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I need two files.

I have fileone with ACCT#, AMOUNT, and STATUS fields. Status is A or B.

I have filetwo with ACCT#, and DEBIT fields.

I want a report that will give me the following totals for each STATUS and for ALL.

Total Amount, Total Debit, Balance for all of Status A

Same for B and same for Total of all records.

I can get close but can't get the Balance for each status separated.

What Fields, and relationships do I need.

It's probably simple but I can't get the right combo.

Larry

Link to comment
Share on other sites

This topic is 7569 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.