find who the driver is

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.
 
J

John_G via AccessMonster.com

See my reply in "New Users" forum.

John


Dale said:
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top