Sum of Like Fields in Different Tables

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.
 
D

Duane Hookom

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.
 
Top