Calculate from 2 fields and place in third

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 2 table columns mapping to 1 drop down and 1 text item fields,
I want to take [column 1 (based on a selection in the drop-down) * column 2]
and place the results in text item 3,

something like: [Get value from table where drop-down = &1] * [column 2]
and this result goes into text item 3, after a value is placed into column 2.

How can I do this?

Thanks for any help.
 
I don't follow. If the combo box has both columns, then the relationship
between the values in each column is one-to-one. So, the result of the
multiplication will always be the same answer when a particular row is
selected.
 
Problem solved.

I removed the 3rd text item, created a query to do the multiplication and
placed this in a report instead of the form.
 
Back
Top