Help with basic query

[UTLee]

I have the following query:

SELECT qryData.client, qryData.USorINTL, Sum(qryData.CatAmount) AS SumOfCatAmountFROM qryData
GROUP BY qryData.client, qryData.USorINTL
HAVING (((qryData.USorINTL) Like "US" Or (qryData.USorINTL) Like "Int*"));

It shows, for each client, the dollar amount of their assets that have been categorized as US equities or International equities. I need another column that sums the two CatAmount values shown for each client, to get the sum total of their US and International equities, while still showing the two separate categories in the query. Any help is much appreciated.

[CJ_London]

try

SELECT qryData.client, Sum(iif(USorINTL = "US",CatAmount,0)) AS USCatAmount, Sum(iif(USorINTL Like "Int*",CatAmount,0)) AS IntlCatAmount,Sum(CatAmount) AS TotalCatAmount
FROM qryData
GROUP BY qryData.client
HAVING (((qryData.USorINTL) Like "US" Or (qryData.USorINTL) Like "Int*"));

[UTLee]

Had to modify it a bit but got it to work. Thanks for your help!