My client tests various materials and they get a report that lists the different elements that were found in their test sample. They do not know what the material is, so they want to be able to enter the amount of the different elements found and show the most likely material matches.
My thought was to start with a table that listed all the materials and how much of each element is in each. The key would be the material name and the feilds would be each element.
I would then create a query entering in the value that was tested for each element. It would then (some how) compare the tested value to the "standard" value and give the closest matches.
I have the query started and got so far as to compare the variation each element, but I am now trying to average the varience of all the elements so I can show a percent match.
Since my varience is a calculated field I am not sure how to use my results in another calculated field.
My next question is - Is there an easier way to do this?