D
David McKnight
I would like to perform a calucaltion using the fields I have in a form
(which are the result of a query) and multiplying by fields in a table not
linked (yet- because I don't know how to).
Form fields [BOM]
[Thickness] & [$/lbs]
subform fields [Project]
[Width] & [Length]
So textbox on form will = [Width]*[Length]*[thickness]*[$/lb]
The object is to get a cost by being able to choosing a length-width
combination or thickness-$/lb combination or both.
(which are the result of a query) and multiplying by fields in a table not
linked (yet- because I don't know how to).
Form fields [BOM]
[Thickness] & [$/lbs]
subform fields [Project]
[Width] & [Length]
So textbox on form will = [Width]*[Length]*[thickness]*[$/lb]
The object is to get a cost by being able to choosing a length-width
combination or thickness-$/lb combination or both.