C
chris
If the form of your data is suitable you could use the
following code in the FormCurrent event
txtMiles.value = dsum
("MilesField","YourTable","RowKeyNumber <=" & cstr
(Me.RowKeyNumber))
and similar for duration.
numbered in order of entry.
is, If I scroll through to record 234 on my form, how do i
get the form (or possibly a subform) to show the sum
of "duration" and "miles" of records 1 through 234, etc.
of the current record that I am on and use that as the
upper limit in my search.
following code in the FormCurrent event
txtMiles.value = dsum
("MilesField","YourTable","RowKeyNumber <=" & cstr
(Me.RowKeyNumber))
and similar for duration.
data for the entire database. For simplicity, each row is
numbered in order of entry.
beginning (1) to whatever record I am currently on? That
is, If I scroll through to record 234 on my form, how do i
get the form (or possibly a subform) to show the sum
of "duration" and "miles" of records 1 through 234, etc.
will do that but I want a query(?) to look at [Field_ID]
of the current record that I am on and use that as the
upper limit in my search.