Schedule workers production time

[doc6]

I am sorry that I didn't explain my problem quit clearly. I have a set of items that need to be produced based on a run rate for example:<br>run_rate&nbsp;&nbsp;&nbsp;&nbsp;count_of_items&nbsp;&nbsp;time_to_complete time_of_day<br>30&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;12&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;24&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;?<br>30&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;8&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;16&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;?<br>30&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;14&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;?<br>I tried to do a running total with DSum in a total query to create a time of day but cannot. each item has a unique key number. Once I get a running total of time I then can place my break and lunch times in at every 120 minutes(2 hour intervals). I need to figure out how i can get the time of day each item takes to complete plus adding in break times and lunch times. I can get running totals on a report but that does me no good in the fact that i have to add the break and lunch times in. These counts and run_rates are updated daily, so there is no fixed count or run rate. Thanks Again.

 

[DaveMac]

Hi there just wondering if you are working on a way to schedule it looks like that’s what you are doing.&nbsp;&nbsp;I am working on the same thing, a scheduling package for access. Unfortunately I do not have the time to go into it but I am looking for someone working on the same type project to share info with I am having a tough time with getting it on a calendar. <br><br><br>Thanks,<br>David<br><br><br><br>e-mail <A HREF="mailto:McDonald.David.A.M@Worldnet.att.net">McDonald.David.A.M@Worldnet.att.net</A> <br>