HOW TO SUM TWO DIFFERENT QUERIES.. PLEASE HELP

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

Duane Hookom

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.
 

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

Top