HOW TO SUM TWO DIFFERENT QUERIES.. PLEASE HELP

  • Thread starter Thread starter KLZA
  • Start date Start date
K

KLZA

Hi. I have two queries based on the same table. I need to sum the
results of both. Example, Query 1 includes a Sum(field1) and Query2
has Sum(field1). I need the sum of both fields in another Query.
Something like Query1 Sum(field1) + Query2 Sum(field1) = Some
result.... Can anyone help?
 
Do the queries each return a single record and single field? If so, try

SELECT Query1.Field1 + Query2.Field1
FROM Query1, Query2;

If this doesn't work, you need to provide more information about your two
queries, their fields and data.
 
Back
Top