Help on consolidating data
Posted on 2011-03-16
I have a table of data with the information coming from our testing equipment. The data in this file is made up. What I need is a way to look up the information by Cert ID and be able to generate a report or form only showing Heat Number, Avg. of Yield, Avg. of Tensile, and also a box stating the bend test was formed, and welded tensile test was performed.
Example, search for Cert ID 10, and in a report/form the correct information display so that I can print it.
Also, I need to put a description with this certified, so I have a table with descriptions. Is it possible to have a feature in access that lets me have a lookup feature by weight that opens with a command buttton, and where I can scroll to the weight that I need and the description inserted on to the report. We have weights that are the same, but the descriptions are different. So making the weight the primary key would not be a good choice.
Any help appreciated..