Calculations in Different Tables

[gatsby]

Hello everyone,

How to get values from other Table to be place on Query for calculation? For example:

Unit Weight is in a different Table while these data - Year, Escalation, Rate Basis, and Contingency are in a different Table also. I want them to see each other in the Query for the calculation, is that possible?

Like:

Unit Weight (from Table 1) * 850 * Escalation (from Table 2) * Contingency (from Table 2)

[JoeM]

Link the two tables together in a query. Then all the fields from both tables are available to you for calculations.