Help with a Form based off of a Table

[AccessGal]

My co-worker wants to enter quantities for the man-hours used for each cost
code.

My table is Time Card Hours, fields are TimeCardDetailID-primary key;
Employee Number; DateWorked; Job Number; Cost Code; Reg Hrs; OT Hrs; DT Hrs
and Description of work. Cost Code Table, fields are Job Number, Cost Code,
Description of Work, and Unit of Measure (UM).

Since we repeat the cost codes for each job (Ex. Job # 00000 and 11111 would
use the same cost code number but the description would change). With that I
created an additional table for cost codes and descriptions associated with
Job # 11111 with the same fields as the Cost Code Table but the Description
of Work field list work performed for that Job # only.

Queries are All Man-Hours job specific base off Time Card Hours Table and
the job-specific cost code table for Job # 11111. Fields are Job #, Cost
Code, Description of Work, UM, MHrs (sum of hours worked) and Date Worked
(exp_from start date to present).

This is what I need the job number; cost code total hours worked on a cost
code; unit of measure and description of work; hours worked this week; Total
man-hours from start to present;quantities to date; estimated man-hours; %
complete; estimated quantities; man-hour units; actual man-hour units;
calculated man-hours and gain / loss. This needs to be a table with a form
for entering this info and the table needs to show all the cost codes and
man-hours to date and then include the hours this week as it relates to each
cost code which may not include all 151 cost codes.

Please help, and thank you!

 

[Arvin Meyer MVP]

First, I assume this is either manufacturing of construction. There should
be way more than 151 CostCodes. On the construction databases I've built,
there may have been as many as 2000, of which 300 to 350 were related to
labor. The CostCode and its Description and Active were the relevant fields
in tblCostCode.

tblTimeCard should have the following fields:

JobNumber
DateWorked
CostCode
HrsWorked
PayRateID

tblPayRate has 2 fields:
PayRateID
PayRateType

All other data can be calculated in a form or report. tblTimeCard is the
only table which active daya to day data in entered into.