P
pat12
Hello everyone
I feel it should be possible in access but have no idea how.
There is a company with number of cars (transporting goods). They have
table which gather information about every transport they done. One
record is one day of work of the car (and drivers)
It looks like this:
table1
car number;date;destination;driver1 name;driver 1start time;driver1end
time;driver2 name;driver2start time;driver2 end time;km paid;km non
paid;kg loaded;kg unloaded;km counter value (when unloaded)
records looks like:
order nb;cn;date;dest;d1n;d1s;d1e;d2n;d2s;d2e;kmp;kmnp;kgl;kgunl;kmcv
1;c1;01/09/2006;place1;dr1;08:00;16:00;dr2;16:30;22:00;0;0;1000;0;0
1;c1;02/09/2006;place1;dr1;08:15;16:15;dr3;17:00;23:00;800;300;0;900;153200
2;c2;02/09/2006;place3;dr4;08:00;17:00;0;0;0;0;0;800;0;0
3;c1;15/09/2006;place1;dr1;08:00;16:00;dr2;16:30;22:00;500;50;1000;900;153750
There are of course thousands of record like this with. Many cars;many
destinations;many drivers;many years. The info about start time ;end
time;km paid;km unpaid;km counter value is received via sms from the
drivers (less sms is better bacause of costs)
My problem is that to verify the info from the drivers i have to
calculate (among other things) the real distance driven and that could
be done in my opinion only by km counter value. To calculate the
distance I should have km counter value form current record and km
counter value from record which (have the same car number, have date
biggest from smaller than current (there are of course many smaller
dates for this car) , have field km counter value different than 0 ,
have different order nb than current)
And that is what I don't know how to do.
Any ideas appreciated
Many thanks in advance
PAT
I feel it should be possible in access but have no idea how.
There is a company with number of cars (transporting goods). They have
table which gather information about every transport they done. One
record is one day of work of the car (and drivers)
It looks like this:
table1
car number;date;destination;driver1 name;driver 1start time;driver1end
time;driver2 name;driver2start time;driver2 end time;km paid;km non
paid;kg loaded;kg unloaded;km counter value (when unloaded)
records looks like:
order nb;cn;date;dest;d1n;d1s;d1e;d2n;d2s;d2e;kmp;kmnp;kgl;kgunl;kmcv
1;c1;01/09/2006;place1;dr1;08:00;16:00;dr2;16:30;22:00;0;0;1000;0;0
1;c1;02/09/2006;place1;dr1;08:15;16:15;dr3;17:00;23:00;800;300;0;900;153200
2;c2;02/09/2006;place3;dr4;08:00;17:00;0;0;0;0;0;800;0;0
3;c1;15/09/2006;place1;dr1;08:00;16:00;dr2;16:30;22:00;500;50;1000;900;153750
There are of course thousands of record like this with. Many cars;many
destinations;many drivers;many years. The info about start time ;end
time;km paid;km unpaid;km counter value is received via sms from the
drivers (less sms is better bacause of costs)
My problem is that to verify the info from the drivers i have to
calculate (among other things) the real distance driven and that could
be done in my opinion only by km counter value. To calculate the
distance I should have km counter value form current record and km
counter value from record which (have the same car number, have date
biggest from smaller than current (there are of course many smaller
dates for this car) , have field km counter value different than 0 ,
have different order nb than current)
And that is what I don't know how to do.
Any ideas appreciated
Many thanks in advance
PAT