TheOfficeSlave
IS-IT--Management
I cant get a calculated value from a query to display in a text box within a subform. All it shows is #Name?.
We have an item with a Type, length & quantity fields, of which we need a total, based on a fixed unit cost looked up from another table, based upon the selected type.
Another way to put it is .....
We have 2 fields in the subform, which both come from combo boxes and need to be multipled together, then divided by 1000, then multipled again by a value in a different table that is associated to a 3rd value choosen in another combo box.
Thanks a ton!
TheOfficeSlave
We have an item with a Type, length & quantity fields, of which we need a total, based on a fixed unit cost looked up from another table, based upon the selected type.
Another way to put it is .....
We have 2 fields in the subform, which both come from combo boxes and need to be multipled together, then divided by 1000, then multipled again by a value in a different table that is associated to a 3rd value choosen in another combo box.
Thanks a ton!
TheOfficeSlave
