how to total the values in a numeric column?

I'm building a report using the matrix control. I have financial data in
different line items (Salary, Rental Expense etc) that needs to be shown by
month (so the columns have months). I have it pretty much working but can't
figure out how to sum up the numbers in each column at the bottom so I can
have a total for every month. Could anyone help?
Thanks a lot.
BobRight-click on the row field that you wish to total, in your case it
would be the Salary field. Choose Sub-total from the menu.
To format the subtotals you need to right-click->properties on the tiny
green triangle that appears on the Total cell.|||ahhh. I was thinking this must be something really simple since it's such a
common function. You can't believe how much time I had spent trying to
figure this out. Thanks a lot.
Bob
"grahamiec" <grahamrichter@.gmail.com> wrote in message
news:1123769689.664448.10490@.g14g2000cwa.googlegroups.com...
> Right-click on the row field that you wish to total, in your case it
> would be the Salary field. Choose Sub-total from the menu.
> To format the subtotals you need to right-click->properties on the tiny
> green triangle that appears on the Total cell.
>

How to test a string for numeric?

How do I test if a varchar column contains a numeric value?What is wrong with IsNumeric()?
http://www.aspfaq.com/show.asp?id=2390
AMB
"Snake" wrote:

> How do I test if a varchar column contains a numeric value?
>|||CREATE TABLE #foo
(
bar VARCHAR(12)
)
SET NOCOUNT ON
INSERT #foo SELECT 'aaaaa5aaaa'
INSERT #foo SELECT '5aaaa'
INSERT #foo SELECT 'aaaa5'
INSERT #foo SELECT 'xxxxx'
INSERT #foo SELECT '.'
SELECT bar, ContainsNumeric = CASE
WHEN bar LIKE '%[0-9]%' THEN 'Yes'
ELSE 'No'
END
FROM #foo
DROP TABLE #foo
"Snake" <Snake@.discussions.microsoft.com> wrote in message
news:EF4FDF27-7F2B-4BF9-A8CE-6EE1E5C9C74F@.microsoft.com...
> How do I test if a varchar column contains a numeric value?
>