Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2009
    Posts
    1

    Unanswered: Multiple names query running totals

    I have a database set up for a company where in one of the tables i have a set of orders where some are locked because they are completed. At the moment each sale by a customer is in a new row on the table.

    I need to run a query to have a total for all of the customers totals. this needs 5to be a running total and everytime a new sale is completed the total has to be updated.

    Will it be best to create a whole new table or run it through a query. any help would be appreciated.

    Sorry if it is not explained very well but i am new to this.

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Why does it have to be a query? Running Sums are easier done in reports.
    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
  •