using sum

[Former Member]

hi ,

if i have two or more numeric type fields in my table and i am using the

SUM to give me a grand total of only one field(column). Does the sum calculate

the sum of the field i wanted or all the fields with numeric datatypes present

in the table.

[Former Member]

Hi,

Yes..It will sum up all the numeric fields..

Thanks,

Naren

[Former Member]

Hi vijay..

It will sum up all the numeric fields.........

u should be care full when you are using <b>sum</b> because the sum of the values in any field may cause an overflow and it may go for a dump.....

Suresh....

[Former Member]

Hi ,

it will sum up all the field of type I , P , N.

[Former Member]

Hi

It will sum up values of fields with domain data type N, I, P.

Pulokesh