S
SailorRoy
I have two tables: One table “Job Time Table†that has fields for the
JobOrderNumber, PartNumber, TimeCharged, PartsProduced , plus other
information such as date, scrap, etc. When we receive an order we issue it a
Job Order Number. We then manufacture the parts over a period of days or
weeks. Each day the time and information is enter into the database “Job
Time Table†I now want to run a report or query to total the Parts Produced,
total time etc. and compare it to the allowed time from the next table “Part
Numbers Tableâ€. The “Part Numbers Table†has the part numbers and the
EstimatedTime, EstimatedMaterails, etc. allowed for each part with other
information.
How do I make this query? I can get part of it but how do I get it to
access the information from the Part Number table and compare. I am totaling
the time etc. to the Job Number information but need to get the estimated
time by the part number. I am using Access 2007.
JobOrderNumber, PartNumber, TimeCharged, PartsProduced , plus other
information such as date, scrap, etc. When we receive an order we issue it a
Job Order Number. We then manufacture the parts over a period of days or
weeks. Each day the time and information is enter into the database “Job
Time Table†I now want to run a report or query to total the Parts Produced,
total time etc. and compare it to the allowed time from the next table “Part
Numbers Tableâ€. The “Part Numbers Table†has the part numbers and the
EstimatedTime, EstimatedMaterails, etc. allowed for each part with other
information.
How do I make this query? I can get part of it but how do I get it to
access the information from the Part Number table and compare. I am totaling
the time etc. to the Job Number information but need to get the estimated
time by the part number. I am using Access 2007.