Calculate Leadetimes in MS Access 1

[tj63069]

I have a production schedule that show I need to run the Parent part at 23:32 hrs (Time Format Only). I have a subassembly part that needs to be supplied to Assembly but takes 5.4 hours to produce and ship. Trying to create a 5.4 hour leadtime for the Sub Assembly Schedule. Need to deduct 5.4 hours from 23:32....In Excel I'm Using =B3-TIME(0,N3,0). But the problem is NO DATE for changes falling into the next day. Want to use access and ODBC the master schedule.

 

[SkipVought]

Hi,

You need DATE & TIME!

Any production schedule need to run on date/time (which is really a NUMBER)

You're manufacturing spans should be duration day/time values as parameters of each part.

So when you add a span to a date/time you get the date/time for the next event in the production schedule.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[SkipVought]

For instance, your parent part must go into work on a particular date at 23:32. Then subtract the span to get the sub assy inwork date/time.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[SkipVought]

Regarding generating a schedule in a query, it can be driven from a parent-child table that describes you bill of material. Each row should have at least Parent, Child, Quantity, Mfg Span.

I use VBA code to do a recursive call to build the schedule from the data in the BOM.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]