SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Member
    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.
    Attached Images Attached Images
    Last edited by DTA; Feb 10, 2005 at 03:37. Reason: Include Graphic Attachment to show problem

  2. #2
    SitePoint Member
    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.
    Attached Images Attached Images


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •