Getting the total of column in other query

[Harr777]

I'm trying to get the sum of a column which is the result of another query. I'm not sure how to get that value.
Thanks in advance.

 

[nicsin]

Hi,

you could try:

select sum(query1.field1) from (select field1 from table1) as query1

nicsin

 

[JonFer]

Is the result of the other query a single value or multiple records?

If there are multiple records, your query to get the sum should use this field expression:

SumOther: (Select Sum(field1) from otherquery)

If you need to restrict which records in otherquery get included, you need to do this:

SumOther: (Select Sum(a.field1) from otherquery as a
Where a.KeyField=thisquery.KeyField)

 

[Harr777]

I see, it's like getting the sum of a value in a table.
Thanks for putting up with my newness.

 

[nicsin]

Yep! you can treat any query as a table. it is just a recordset after all.... ;-)

 

[nicsin]

well...having said that, don't get too excited and start inserting records! it won't happen