forecast production days

[Guest]

Some Please give me a start on this one, third day in a row i text this
message..


my query as two fields:
description minutes need
where description is the name of my product and 'minutes need' is the
minutes i'm gonna need to finish the job.
my problem is a bit complicated, i hope u understand and be a bit patiente..
In my factory we work 7.00 till 2.00 - That's 19 hours (1140 minutes)
knowing how many minutes i need to finish my products, i can forecast the
daily times of starting and finishing a product.
But, there's breaks (9.30 till 10.00) and (12.30 to 13.00), etc
how can i transform this:
description Minutes Need
Rump 200
sirloin 200

into this:
description Minutes Need Minutes(Dsum)
Rump 150 150
break 30 180
rump 50 230
sirloin 100 330
break 30 360
sirloin 100 460

where i Can define when the breaks are in a table like:
Break code Between and
1 150 180
2 330 360
etc..
sorry, i know is alot to ask, but any START our IDEIA will be very apreciated



thank u.

 

[JohnFol]

This presumes a start time for each entry as you need to know when you are
going to hit a break.
I would suggest you cannot do this in a query as you would need a row for
every minute there is a break in order to do some sort of Not In clause, and
even then, how would you count part of the 200 for Rump that is not in a
break. ?

I think the only way you can do this is via code, and for each of the 200
rump minutes, check to see if it's break or not. If it sis not, you
increment a counter up to the berak time (in your example 150 minutes), and
re-commence counting when it is no longer break time.

Alternatively, look at something like MS project which is designed to
forecast resources against working patterns. It may be you could automate
Project but I've not tried it.

 

[JohnFol]

Hi Roy, having complained that no-one offered to give up their free time to
help you for the "third day in a row ", when someone does, it might be
polite to acknowledge them, otherwise people would be less inclined to help
in the future.

 

[Guest]

thank u jonh, i will try project inside access.

Hi Roy, having complained that no-one offered to give up their free time to
help you for the "third day in a row ", when someone does, it might be
polite to acknowledge them, otherwise people would be less inclined to help
in the future.