A
Adam Schlachter, NJ
Hi,
I am working on a database and I need to come up with a way to create an
entity (form, query etc.) that will perform a calculation. Here is the basic
example. We collect data from facilities for 30 different materials.
Facilities will either report the data as cubic yards OR pounds/tons of
material. The goal is to create an entity which can take the raw cubic yard
numbers (ie 50 cubic yards) and multiply it by the necessary conversion
factor, divide by 2000 and make it into a final tonnage number. Ex. 50
cubic yards of wooden Pallets. Eacy cubic yard of wooden pallets weighs
363.64/lbs/cy therefore the final tonnage is 9.091 tons. So I would want the
reporter to select Pallets as the conversion factor, type in 50 for the cubic
yards and generate 9.091 as the tonnage value.
I don't know if there is an easy way to do this. Not too much experience
programming VBA but it seems to me that I should be able to create something
basic.
Thanks for any help anyone can give!
Sincerely,
Adam Schlachter
I am working on a database and I need to come up with a way to create an
entity (form, query etc.) that will perform a calculation. Here is the basic
example. We collect data from facilities for 30 different materials.
Facilities will either report the data as cubic yards OR pounds/tons of
material. The goal is to create an entity which can take the raw cubic yard
numbers (ie 50 cubic yards) and multiply it by the necessary conversion
factor, divide by 2000 and make it into a final tonnage number. Ex. 50
cubic yards of wooden Pallets. Eacy cubic yard of wooden pallets weighs
363.64/lbs/cy therefore the final tonnage is 9.091 tons. So I would want the
reporter to select Pallets as the conversion factor, type in 50 for the cubic
yards and generate 9.091 as the tonnage value.
I don't know if there is an easy way to do this. Not too much experience
programming VBA but it seems to me that I should be able to create something
basic.
Thanks for any help anyone can give!
Sincerely,
Adam Schlachter