SitePoint Sponsor |
|
User Tag List
Results 1 to 2 of 2
-
Feb 10, 2005, 00:19 #1
- Join Date
- Feb 2005
- Posts
- 2
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
MS ACCESS Problem with Sub total Values
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.Last edited by DTA; Feb 10, 2005 at 04:37. Reason: Include Graphic Attachment to show problem
-
Feb 10, 2005, 21:47 #2
- Join Date
- Feb 2005
- Posts
- 2
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Simple Solution
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.
Bookmarks