Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Location
    Nova Scotia Canada
    Posts
    1

    Unanswered: Sum of a distance up to a record

    I need help totaling a distance. I will explain what I am trying to do.

    Record 1, 30m Record 2, 32m Record 3, 28m

    Now I want to view each record in a form so you will see

    Form 1, 30m Total 30m Form 2, Total 62m Form 3, Total 90m

    I can get the form to show the total of all records which is 90m but when I view Form 2, I want it to show the total of record 1 and 2 only.

    I Thank you for any help.

  2. #2
    Join Date
    Nov 2003
    Posts
    267
    Go to microsoft knowledge base and search for "QrySmp00.mdb" under Access 2000 category

    this DB hold several examples of different queries. One which shows you how to do a running total. You will use the query to populate your forms and maintain the running total

    S-

Posting Permissions

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