S
Steve
I am running Access 2000 and I am setting up a production
scheduler for a manufactured home dealer. There are 26
stations a house must go through before it is finished.
Each station manufactures 4 floors per day, so it takes
6.5 business days (no weekend days) for a home to be
completed after it has been started. I need a report
that has the following fields:
PRO# Customer_Name Model_Num Num_floors Start Complete
7788 Smith A-3256A-08 2 10/1 10/8
7789 Brown B-3259A-06 2 10/1 10/8
7790 Jake C-4071A-20 3 10/2 10/9
I am having a hard time calculating the Start Date and
Complete date for each home based on a 4 floor per day
production rate. Can someone help me out with this? I
need holidays and weekend days omitted.
thanks, Steve
scheduler for a manufactured home dealer. There are 26
stations a house must go through before it is finished.
Each station manufactures 4 floors per day, so it takes
6.5 business days (no weekend days) for a home to be
completed after it has been started. I need a report
that has the following fields:
PRO# Customer_Name Model_Num Num_floors Start Complete
7788 Smith A-3256A-08 2 10/1 10/8
7789 Brown B-3259A-06 2 10/1 10/8
7790 Jake C-4071A-20 3 10/2 10/9
I am having a hard time calculating the Start Date and
Complete date for each home based on a 4 floor per day
production rate. Can someone help me out with this? I
need holidays and weekend days omitted.
thanks, Steve