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,

Why not use the Aggregate SUM() function in Access to do this?

SELECT SUM(column) from Table where value = value?

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html
================================================== =========
Why can't Programmers, program??
http://www.codinghorror.com/blog/archives/000781.html
================================================== =========

OK thanks