Sum of Like Fields in Different Tables

  • Thread starter Thread starter Laz
  • Start date Start date
L

Laz

Been searching everywhere...I want to sum columns of numbers from two
different tables and have the results displayed as one number. Anyone have
any suggestions.
 
Create a totals query based on a UNION query. The union query will select
the columns from the two different tables. The totals query can sum them.
 
Back
Top