D
Dale G
Hi,
I’m trying to identify a route driver based on the route number the location
& the time the route was at the location.
I have many routes with the same number (i.e. 100, 200, and 300). All routes
of the same number use the same stops (1st Ave, 5th Ave Jefferson St etc).
All the stop locations are associated with a time the route is scheduled to
stop at that location (Zone).
What I’m hoping to do is, use a series of combo boxes or list boxes or even
a report to find who the driver is by searching the route, location, and
time.
The driver is assigned a piece of work (this is called a run) that has many
routes, and the piece of work is identified by a number i.e. 10, 20, 30, 40,
etc.
A driver’s piece of work with the number of 10 (Run 10) could have route
100, 200, 300, and 200 again which is a full day of work.
Another driver could have a piece of work (a run) with the number of 20 (Run
20) and have the same routes as the driver with number 10 (Run 10) .
The difference would be the scheduled time the driver preformed the route.
So far my tables are,
tblEmployees
EmpID, AutoNumber Primary Key
DepID, Number
JobTtlID, Number
EmpNo, Number
EmpStart, Date/Time
tblRoutes
RouteID AutoNumber Primary Key
RouteNumber, Number
RtDir, Text, this is the direction i.e. N or S
IsAlt, Yes/No, in case the route is an alternate
tblRuns
RunID, AutoNumber Primary Key
RumNumber, Text
tblRunRoutes
RunRtID, AutoNumber Primary Key
RunID, Number
RouteID, Number
StartTime, Date/Time
tblZones
ZoneID, AutoNumber Primary Key
ZoneName, Text
tblTimePoints
TimPtID, AutoNumber Primary Key
RunRtID, Number
ZoneID, Number
TimPt, Date/Time
Also I’ve set a combo box up on a form with
SELECT Routes.RouteID, [RouteNum] & " " & [RtDir] & " " &
IIf([IsAlt]=True,"A","") AS [Route Number] FROM Routes;
To receive the route numbers. So far that’s it.
Any help is appreciated.
I’m trying to identify a route driver based on the route number the location
& the time the route was at the location.
I have many routes with the same number (i.e. 100, 200, and 300). All routes
of the same number use the same stops (1st Ave, 5th Ave Jefferson St etc).
All the stop locations are associated with a time the route is scheduled to
stop at that location (Zone).
What I’m hoping to do is, use a series of combo boxes or list boxes or even
a report to find who the driver is by searching the route, location, and
time.
The driver is assigned a piece of work (this is called a run) that has many
routes, and the piece of work is identified by a number i.e. 10, 20, 30, 40,
etc.
A driver’s piece of work with the number of 10 (Run 10) could have route
100, 200, 300, and 200 again which is a full day of work.
Another driver could have a piece of work (a run) with the number of 20 (Run
20) and have the same routes as the driver with number 10 (Run 10) .
The difference would be the scheduled time the driver preformed the route.
So far my tables are,
tblEmployees
EmpID, AutoNumber Primary Key
DepID, Number
JobTtlID, Number
EmpNo, Number
EmpStart, Date/Time
tblRoutes
RouteID AutoNumber Primary Key
RouteNumber, Number
RtDir, Text, this is the direction i.e. N or S
IsAlt, Yes/No, in case the route is an alternate
tblRuns
RunID, AutoNumber Primary Key
RumNumber, Text
tblRunRoutes
RunRtID, AutoNumber Primary Key
RunID, Number
RouteID, Number
StartTime, Date/Time
tblZones
ZoneID, AutoNumber Primary Key
ZoneName, Text
tblTimePoints
TimPtID, AutoNumber Primary Key
RunRtID, Number
ZoneID, Number
TimPt, Date/Time
Also I’ve set a combo box up on a form with
SELECT Routes.RouteID, [RouteNum] & " " & [RtDir] & " " &
IIf([IsAlt]=True,"A","") AS [Route Number] FROM Routes;
To receive the route numbers. So far that’s it.
Any help is appreciated.