Displaying hours in a form given a start and end time

[tkoczkodan]

I have a form I am using to track production and production efficiency. I have built it so that the operator enters an hourly count. The start and end times change based on each run. What I would like is to display the time frame (i.e. 15:00-16:00) as a label for each hour an entry is needed based on the start and end time. So if start time is 14:30 then first hour is 14:30-15:00, second is 15:00-16:00 and so on to the last hour as defined by the end time. Huge question to ask, but if someone could give me a starting point, that would be great. Thanks!

[TG_W]

Are you wanting to see the information in the same form? I'm not sure how many other fields you have, but it almost sounds like you might need to use a crosstab query and present the data in another form/report.

Also, what other parameters are you using to define efficiency? Only using time spent is not a good indicator for measuring efficiency, especially when unknown variables occur (i.e. a piece of equipment fails, procured order arrives later than anticipated slowing the start of production, etc.).

[tkoczkodan]

I would like to see the infomation on the same form, as a label if possible.

I am using a production standard to calculate efficiency which I am pulling from another table in the database. The standard is shown on the form after the user enters a part number and work center. The labels are place holders for the operator, but the time is more desirable as I can later look for patterns during production runs (i.e. problems with setup, early shutdown).

I used to do this in excel but the files got huge and the time spect replicating them was a pain, so I am trying to set up a database for the same purpose.

[TG_W]

Ok on the efficiency calculation.

Are you wanting to create a count of hours worked during a specific time frame is why you are wanting the hours to show as a label, so to speak? After looking at a crosstab query, it would set up time breakdown like what you are describing, so it would probably take a few nested queries to get the information to show like you want. I think it's possible, though.

And to clarify, are the operators entering a start and end time, or start time and number of hours worked?

[tkoczkodan]

Operator enters start time and end time. The end time may change based on actual production. So the time "labels" would accomplish two things for me: give a time frame for the operator so he knows what count he is putting in (14:30 - 15:00, 15:00-16:00) and second, give me the number of minutes in the hour to calculate a target based on the standard. So if there is only a 40 minute hour in there (say 15:00-15:40) my target is based on 40 minutes. If it would be easier just to do a field in the form that autofills based on start and end time (like I did in excel) thats fine too. But I'd love the opportunity to pick up some experience with Access.

[TG_W]

Sorry to take so long to get back to you.

I'm actually working on doing something similar for my company's reporting to replace a complicated series of Excel files with a lot of macros, none of which validate the data causing end users problems. I'll be working on it through today, so I'll post back with the series of queries I use to get what you are looking for.

[tkoczkodan]

Hi, TG_W, was wondering if you were able to come up with anything?

[TG_W]

tkoczkodan,

We had a person leave our department, so I've been thrown in to admin another system and wasn't able to get any further as I had to go for training from the software developer.

A couple of ideas I was working with was some sort of chart embedded in the form, either a vertical bar or a Gantt chart. This link is to an article on Gantt charts in Access and other Microsoft products I started going through when I got redirected. - http://www.brighthub.com/computing/w...les/57933.aspx