23 Replies Latest reply: Dec 1, 2010 10:59 AM by Oleg Troyansky RSS

    Multiply two fields from different tables

      Hello!! I need some help with multiplying data from two tables into one new field having one field in common between both tables.

      I have Table1 with fields: [Machine] and [Speed] and Table2 with fields: [Machine] and [ProdHrs], I need to have a new field (in Table2) that has the product of [Speed] and [ProdHrs] for each record of [Machine].