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.
 
Thank you for sending me in the right direction, got it working.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUM in a UNION query 2
Total Query: Adding a field to a calculation. 3
SUM - IF - AND 7
HOW TO SUM TWO DIFFERENT QUERIES.. PLEASE HELP 1
Displaying * items along with total sum 2
sum of row when duplicate entries of date, difference between 2 ta 1
Aggregate Query in Access 2007 1
Joining tables 1

Back
Top