Sum values in a column

Hi,

I want to have the sum of the values of a column .. however the range is not definate.. a.. i.e we need to check till the last rec.. and need to get the sum

pls help

[196 byte] By [Sreeja] at [2008-1-2]

«« Open e-mail in a Compose window in Pocket Outlook
»» New OleDbCommand

# 1

Use the matrix report.

mverma at 2007-9-13 >

top of Msdn Tech,SQL Server,SQL Server Reporting Services...

# 2

i am new to VBA .. so donot understand wht u meant by matrix report ..

Sreeja at 2007-9-13 >

# 3

When you total a column in a table, it totals everything in that column in that table. If you have a filter on that table, you will be totalling the subset of the data that the filter allows. You really need to specify what you mean by "the range is not definate". Are you meaning that you want to total everything regardless of filters?

sluggy at 2007-9-13 >

# 4

Just open your project and select the matrix report,

select the column group and row group ie. what will be your column and rows then select the subtotal

it will give you total of all the columns and rows in the last colmn as well as rows

Regards,

Manoj Verma

mverma at 2007-9-13 >

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Question about 'Sum values in a column', No.1493161,Posted by Sreeja

Sum values in a column

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Site Classified