Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Posts
    233

    Unanswered: adding totals to a rpt

    I have a rpt very simple

    fields employee, balance

    the query for the report will return all charges made buy an employee
    in the report i want to summarize this, and have 1 line for each employee with the total balance for that employee, this is done
    I added grouping to the report for employee

    i want now a total for all employees there are 2 txtboxes in the grouping area
    txtEmp & txtBal

    in the page footer i put a txtbox with the formulat =sum(txtBal) and it doesnt work! what am i doin wrong

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Put the =Sum(txtBal) in the REPORT footer not the PAGE footer.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

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