Setting up table and form for scheduling Hours

[data59]

Sorry if this seems like a duplacate post but I changed directions in my project and did not want to confuse the issues. so hears my my delema.


Suppose I have a table that has the following fields

[Job#]---[Mach Operation Type]--[Startdate(Monday of week)--[ Job duration-(Weeks)]

I would like to display the data in a format like this:

[Job#]---[Mach Operation Type]--[Total weekly Hours of Job Function]

I would like to display this in a form or report that would show this information and show a week number for each week of the year. I would like the formula to be the total hours for the job divided by the job duration, and deposited the product in to the week number. The start week to deposit the product would be keyed off the start date i.e. total job duration 3 weeks , total hours for the job 300hr = wk1-100hr, wk-2 100hr, wk-3 100hr

Report example:
[Job#]---[Mach Operation Type]--[Total weekly Hours of Job Function] [Wk1]-[Wk2 ]-[Wk3]-ect----

Will I need a new record for each week?

It would be similar to the way a calendar program work I suppose, but I’ cant seem to get my head around it and I am still pretty new to coding in VB. Any ideas would be greatly appreciated. Thanks