Hi
I have a table with over 100 fields that has the following fields: OrderNo, DateCompleted, DrawingNo, 1, 2, 3, 4, 5.......50, 111111,111112,111113,111114......111200. 1 to 50 being the inspectors' stamp number. For every completed job, there is 1 point rewarded to the job which is divided by the number of inspectors on that completed job. There can be up to a maximum of 5 inspectors per job completed based on one drawing. That means one order can have up to 10 drawings.And 111111 to 111200 being the job numbers which the inspectors are assigned to. One drawing can have up to 5 jobs.This table has information for a large number of different jobs. I am hoping to run a query or report against the table and find breakouts of which inspector has the most points and what kinds of jobs he has done and also how do i create a form per drawing to determine how many inspectors are doing on one drawing. Each drawing has many different job numbers and inspectors working on them. I appreciate all of your wisdom in explaining how this should be done. I hope this is not too confusing.
Thanks in advance.
I have a table with over 100 fields that has the following fields: OrderNo, DateCompleted, DrawingNo, 1, 2, 3, 4, 5.......50, 111111,111112,111113,111114......111200. 1 to 50 being the inspectors' stamp number. For every completed job, there is 1 point rewarded to the job which is divided by the number of inspectors on that completed job. There can be up to a maximum of 5 inspectors per job completed based on one drawing. That means one order can have up to 10 drawings.And 111111 to 111200 being the job numbers which the inspectors are assigned to. One drawing can have up to 5 jobs.This table has information for a large number of different jobs. I am hoping to run a query or report against the table and find breakouts of which inspector has the most points and what kinds of jobs he has done and also how do i create a form per drawing to determine how many inspectors are doing on one drawing. Each drawing has many different job numbers and inspectors working on them. I appreciate all of your wisdom in explaining how this should be done. I hope this is not too confusing.
Thanks in advance.
