var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
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.
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