Query to compare information between tables

[Guest]

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.

 

[kingston via AccessMonster.com]

Create a totals query to sum the time and parts for a job: group by job,
group by part, sum time, sum produced. Create a second query on the first
query joined to your standards table on part number. Output all the fields
you need and add a calculated field where necessary: standard*quantity or
total time/quantity.

 

[Guest]

Okay, I got the first part but I am getting the wrong totals! Second query:
how do I use query to lookup the parts per hour extimated from the second
table? thanks for your help.

Roy

 

[kingston via AccessMonster.com]

What do you mean by getting the wrong totals? If you manually add all of the
time in your table for a job number and part number pair, does this match the
totals query result? What are you getting?

In query design mode, add both the first totals query and the table where you
have estimated times. Drag and drop the part number field from the query to
the table; this joins the data based on the part number. Drag the fields you
want to the output grid. The actual data will line up with the estimates.

Okay, I got the first part but I am getting the wrong totals! Second query:
how do I use query to lookup the parts per hour extimated from the second
table? thanks for your help.

Roy

Create a totals query to sum the time and parts for a job: group by job,
group by part, sum time, sum produced. Create a second query on the first

[quoted text clipped - 16 lines]