Sub-Summary and Grand-Summary with two files?

[LarryLogic]

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