Sum Calculation Query

Hi,

Within an access database I want to be able to add some values and calculate the sum of these values. Using asp.net 1.1. with vb.net, how would I achieve this ?

Presumably I could perform a look up within the databse and then use sind kind of function to add the required values ? Can anyone offer any suggestions or point to any useful online examples ?

Thanks,

reather than use asp.net to add up your columns why not use your datasource to do this.

like an sql query:

select sum(amount)

From TBLIntegerHolder

where amount > 0

something like that

Write a query within access to do the necessary data manipulation and the read the result.

Hi,

Use sum() function in the sql query.

Thanks all