Help Totaling Multiple Columns Values into a Single Field

Ask for Help
1

Hi, I’m trying to summarize this form as I’ve marked it up. Anyone’s help would be greatly appreciated.

Daily Production Form
Daily Production Form2048×796 108 KB

2
  1. Create a separate table you could call Totals with the Categories of your costs table (Equipment, Labor, Material).
  2. Create a relation with match-multiple from Totals to Costs.
  3. Look up the Total column
  4. Do a rollup (sum) on the lookup column.

You could do something similar with the Query column instead of the relation column.

3

This is great. Let me give this a try and see what I come up with.