How do I create an hourly schedule to show who is doing what, & their start/end time? (1 Viewer)

[Jere]

How do I create an hourly schedule to show who is doing what, & their start/end time?

Hello all. Been using these forums & dbforums a lot to answer questions, but just haven't found an answer to a predicament I'm in.

I've created an access database for an ambulance company I work for to help save on monthly costs using some 3rd party program, which tracks everything that we're doing for transporting. We handle both Emergency, non-emergency, and basic transports, so our dispatchers are needing a visual of seeing what our fleet is doing by individual truck.

I found something similar I'm looking for in another post on the dbf forum (can't link cause I don't have 10 posts), and the picture is in the attachment for what I'm looking for. I've tried scouring the internet, and best I can find is monthly scheduling.

In my Table that handles this information, I have a "truck assigned" field, a "Pick-up time" field, & a "drop-off time" field. I posted just the basic tables to this, with sample data.

I do understand this may require exporting to excel to achieve, and that'd be fine. I just would love any assistance into this.

This is being designed and run in Access 2010

 

[Jere]

Re: How do I create an hourly schedule to show who is doing what, & their start/end t

I apologize for the double post, but I wished to add information to this in case this post was being overlooked. I'm not simply just looking for someone to just hand me code for this. I'm looking for directions on how to achieve this, like reading material.

Sadly, my VBA knowledge is very limited, but I'm picking up on how to do different things in Access, but I know this is going way beyond what little knowledge I have. I'm willing to learn if someone can give me a reading list or anything.

 

[Alansidman]

Re: How do I create an hourly schedule to show who is doing what, & their start/end t

the db in that you attached is empty.

Look at this web site for an idea on how to set up your db. This one is for a taxi service which may be similar.

http://www.databaseanswers.org/data_models/taxi_service/index.htm

 

[Jere]

Re: How do I create an hourly schedule to show who is doing what, & their start/end t

the db in that you attached is empty.

Look at this web site for an idea on how to set up your db. This one is for a taxi service which may be similar.

I apologize. I had everything hidden. That is fixed now and they're visible.

I have the databases themselves laid out how I want them, and I have the forms built to handle actually dispatching. I'm just hitting a brick wall trying to research how to achieve what I wish to do.

All I'm trying to figure out is how to create a graphic of all the hours in a day, and show when a truck is being used. Like say I have a trip from 1100 to 1300; I would want the graphic to show a bar from 1100 to 1300, and say the bar is a unique color for only that truck. Or even better, a colored bar with a tripID as text inside.