T
The Report Guy
Hi,
I have the following query the gives me the total Balance by pool. I'm
Trying divide the Sum of each pool to the over all balance within a query.
SELECT POOL, Sum(Portfolio.Balance) AS SumOfBalance
FROM Portfolio
GROUP BY Portfolio.POOL
Example:
Pool Balance %
2006-01 10 67%
2006-02 5 33%
Please advice
Thanks
I have the following query the gives me the total Balance by pool. I'm
Trying divide the Sum of each pool to the over all balance within a query.
SELECT POOL, Sum(Portfolio.Balance) AS SumOfBalance
FROM Portfolio
GROUP BY Portfolio.POOL
Example:
Pool Balance %
2006-01 10 67%
2006-02 5 33%
Please advice
Thanks