This is real difficult, well maybe for me, but I am trying to create an Access program that will project hours remaining for a job assigned. The fields that I need to be displayed are Job, Task, Contractor, Description (these fields are pulled from a table), % complete (which is entered manually), and hours remaining (calculated field-query) and the days of the week (M, T, W, TH, F, S, S) thru 13 weeks.
The way the hours remaining works is
a. Jobs greater than 160 hours each has to be broken down by 32 hour days
b. Jobs less than 160 hours, but greater than 80 hours are broken down by s4 hours
c. Jobs less than 80 hours are broken down by 16 hour days
An examble of how it would look is below:
Job Task Contractor Description % hrs comp Hrs rem M T W TH F S S M--> 13 wks
8560 08 Burks Framinn 0% 12 12
8912 01 Lieman Deck work 85% 161 32-32- 32- 32-25 32...
8815 04 Hilton Siding 0% 120 24-24- 24- 24-24
8650 03 Boyden Columns 0% 78 16-16- 16- 16-14
8112 05 Atlantic Framing 0% 740 11-23- 23- 32-25 32....
Totals 95-95- 95- 95-95
The totals for each day can be no greater than 95 total hrs which is why the numbers are split like that. There are more rules to this, but if I can get this part done first I will give out more points for the additional rules. I probably figured a crosstab would work here, but I could be wrong. Thanks