Jeff, The information (percentages) that are entered in the tables would come from physical inspections and other mechanical methods. Also, I'm not sure what you mean by "mathematically unsound" these percentages would come from the query. I guess the nomenclature of my fields need to be more specific. Let me explain this better: We collect 5 samples of material from bulk loads

Jeff sorry it took so long to get back to you. Here is what I've done: Created a table (tbl PO) with the following fields: PO#(As primary field), Vendor,material type, inspected by, location With exception of PO# the rest get their info from other tables My second table (tbl Percent) has the following: PO#, Ptype%%, paper%%,H20%%, other materials%%, other plastics%% Its primary relationship

Hello, I put togheater a database with the help of some of your responses. For this I thank you. I need to be able to categorize the results of fields on a table, based on a preset criteria. For example: if the sum of Paper%%+OtherMaterial%%+OtherPlastic%% =26 it should show 2 on a text box in the form. Otherwise it would show other values not necessarily number. I have been trying