L
Liz James
How to calculate end of section from a field showing start of each section of
track .
The raw data in the table looks like this (the relevant fields):
Section is the distance in km from the start of the track for a section of
track.
Job No Section Description
1 0.0 Start of track at
4 3.48 Track in fair condition
6 3.2 Small section of track is wet and boggy
16 6.8 Track in steep downgrade
20 13.3 Track condition poor
21 10.4 Track on ridgetop
Below is how I want to display the data
Job No Section start Section end Description
1 0.0 3.2 Track generally flat
5 3.2 3.48 Small section of track is wet and boggy
6 3.48 6.8 Track in fair condition
16 6.8 10.4 Track in steep downgrade
21 10.4 13.3 Track along ridge
20 13.3 Contd. Track condition poor
Section end is a calculated field in a query.
How can I set up the query to display the data as shown above for the
Section end field?
Section end value = section start value for next section. How to set up a
function to do this?
track .
The raw data in the table looks like this (the relevant fields):
Section is the distance in km from the start of the track for a section of
track.
Job No Section Description
1 0.0 Start of track at
4 3.48 Track in fair condition
6 3.2 Small section of track is wet and boggy
16 6.8 Track in steep downgrade
20 13.3 Track condition poor
21 10.4 Track on ridgetop
Below is how I want to display the data
Job No Section start Section end Description
1 0.0 3.2 Track generally flat
5 3.2 3.48 Small section of track is wet and boggy
6 3.48 6.8 Track in fair condition
16 6.8 10.4 Track in steep downgrade
21 10.4 13.3 Track along ridge
20 13.3 Contd. Track condition poor
Section end is a calculated field in a query.
How can I set up the query to display the data as shown above for the
Section end field?
Section end value = section start value for next section. How to set up a
function to do this?