SUM query

[IxiRancid]

Hi,

I'm having some troubles with a SUM query in Access.

How can I sum all values of a field in EVERY table named "amount_cur" by a parameter that I pass?

 

I tried with

SELECT SUM amount FROM table1, table2, table3

just to begin with the SUM, and then pass the WHERE clause but this didn't work as if "multiple cells found in tables" stuff.

[Joe Mamma]

you mean something like this. . .

 

 

SELECT Sum(total) AS GrandTotal FROM

(

SELECT Sum(amount) AS total

FROM table1

union all

SELECT Sum(amount) AS total

FROM table2

union all

SELECT Sum(amount) AS total

FROM table3

)

[vijay_it]

SUM is a group by function. what actually you are intended to do i did not get. if you want to get sum for all table as seperate record then use it in following way

 

select sum(urvalue), groupfield from urtable group by groupfield

union

select sum(urvalue), groupfield from urtable1 group by groupfield

:rolleyes:

[IxiRancid]

you mean something like this. . .

 

 

SELECT Sum(total) AS GrandTotal FROM

(

SELECT Sum(amount) AS total

FROM table1

union all

SELECT Sum(amount) AS total

FROM table2

union all

SELECT Sum(amount) AS total

FROM table3

)

 

 

This would be it, I believe. I'll try it.

Thanks!