N
Novice Jim
I estimate for a mason contractor (bricklaying company). One of our
contractors, a home builder, hires us per job on a time and material basis.
I calculate our final contract amount based on brick type and quantities,
total labor hours, total cost (based on the time and material billed to the
job), and past contract amounts billed for similar sized projects. With this
specific information, I want to calculate (either in a query or in an Excel
workbook) price per brick, price per square footage, production per man day,
etc. All the general information pertaining to these jobs, and hundreds of
jobs for hundreds of other contractors, are tracked in an Access Database.
I've got queries set up to isolate this contractor, per job number, which is
unique to each separate job. The problem I am having is appending the
ever-growing number of completed jobs we do for this contractor with the
related quantities. In other words, I want to be able to track the job
general information, which would be the name, address, city, etc., as we have
done forever in a table named "tblJobInformation", but would also like to
track the specific information (the brick quantity totals, total man hours,
total days needed to complete the job, etc.) for this contractor's job in a
separate table. Then, with these two tables, I have all the information I
need to run my calculations. This is where I'm stuck.
I want to pull just the job name and number from the query I've constructed
to isolate this contractor, and construct a form to enter all the specific
info I listed above. I tried a make-table query to catch all the completed
jobs from this contractor, but the specific information would be erased each
time I ran it.
I know this is probably very simple to all of you, and I apologize for that.
But, I'm stuck!!
Would appreciate any help.
Jim
contractors, a home builder, hires us per job on a time and material basis.
I calculate our final contract amount based on brick type and quantities,
total labor hours, total cost (based on the time and material billed to the
job), and past contract amounts billed for similar sized projects. With this
specific information, I want to calculate (either in a query or in an Excel
workbook) price per brick, price per square footage, production per man day,
etc. All the general information pertaining to these jobs, and hundreds of
jobs for hundreds of other contractors, are tracked in an Access Database.
I've got queries set up to isolate this contractor, per job number, which is
unique to each separate job. The problem I am having is appending the
ever-growing number of completed jobs we do for this contractor with the
related quantities. In other words, I want to be able to track the job
general information, which would be the name, address, city, etc., as we have
done forever in a table named "tblJobInformation", but would also like to
track the specific information (the brick quantity totals, total man hours,
total days needed to complete the job, etc.) for this contractor's job in a
separate table. Then, with these two tables, I have all the information I
need to run my calculations. This is where I'm stuck.
I want to pull just the job name and number from the query I've constructed
to isolate this contractor, and construct a form to enter all the specific
info I listed above. I tried a make-table query to catch all the completed
jobs from this contractor, but the specific information would be erased each
time I ran it.
I know this is probably very simple to all of you, and I apologize for that.
But, I'm stuck!!
Would appreciate any help.
Jim