Microsoft access 2016 not wanting to use VBA really.
I have 1 x meter that record fuel throughput. There is a totaliser at the top of each meter.
Each ltr issued increases the totaliser.
EG Close of day reading 1234567 so the next day 1234567 will be the starting figure.
So 2304 Ltrs issued will increment the figure to 1236871 which will be the start figure for the next day.
Ive tried lots of different variations but cant seem to get this to work. Ideally it will be a form so the data will automatically update once the form has been completed.
Day 1 Start 1234567 500 Issued Finish 1235067
Day 2 Start 1235067 2304 Issued Finish 1237371
Day 3 Start 1237371 1098 Issued Finish 1238469
Hope I've explained well enough.
I have 1 x meter that record fuel throughput. There is a totaliser at the top of each meter.
Each ltr issued increases the totaliser.
EG Close of day reading 1234567 so the next day 1234567 will be the starting figure.
So 2304 Ltrs issued will increment the figure to 1236871 which will be the start figure for the next day.
Ive tried lots of different variations but cant seem to get this to work. Ideally it will be a form so the data will automatically update once the form has been completed.
Day 1 Start 1234567 500 Issued Finish 1235067
Day 2 Start 1235067 2304 Issued Finish 1237371
Day 3 Start 1237371 1098 Issued Finish 1238469
Hope I've explained well enough.
Comment