dividing by dates

[Kevin S]

I'm trying to develop an expression/code that divides up
production hours per week based on the start date and
completion date.

Example: 100 production hours, starting 10/20/03 and
finishing 11/17/03 -- needs to alot 25 hours each week for
4 weeks.

I can calculate the workdays using a DateDiff function,
but how do I tag to the appropriate week? Do I need a
second calculated field in a query to achieve this?
Any suggestions are appreciated!

 

[[MVP] S. Clark]

What do you mean by Tag to the appropriate week?

I assume that you have a child table that has this structure:

Week StartDate
Week Number
Week Allotment

In it you would write the values, and stuff the allotment number too.

What am I missing?


--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-