MS ACCESS Problem with Sub total Values

[DTA]

I am creating a small cash book program in Access 2000

The Cash Payments and Receipts are identified by a Numeric Code to allow for calculation of sub group totals.

The Numbers are Receipts = 1 and payments = 2

Attachment cbook.jpg shows the report with a red circle around the values
that I wish to capture and place in a text box in the lower part of the report.

Attachment fields.jpg shows fields which are currently used on the report.

As can be seen in cbook.jpg the code I am using captures the values in both
sub group 1 and sub group 2. Any suggestions on how I can capture the totals is welcome.

[DTA]

I have used a simple if inelegant solution to calculate the correct figures in
the bottom part of the cash book.

In the query box under the field for the account number I have told it not to print any postings with the account number 301. (Bank Account).

As the posting to the bank account is not shown in the cash book the correct totals for the receipt and payment figures are carried down to the lower part of the report. Please see attached picture of result.

A thank you to those people who looked at my problem even if they could not provide a solution.