sql + vb.net

[dazz]

Hi,

i have a database and a little vb program but now i want to get the sum of some values in one of the table's.

i thought it should be something like 'SUM(blablafield) AS total' but when i try to put this in the querybuilder it always give's some error.

Now i dont really know who to work with sql in visual studio 2005 so can someone explain to me how it works?

tnx

 

[Arg81]

You're on the right lines....as long as the field is numeric the correct SQL code is;

SELECT Sum(FieldName) As Total FROM TableName