Hi everyone! i'm here again with another problem... this time i need to get a total from a field called "cantidad" (quantity) on the database... is there a way to get it with the recordset? or do i have to make another thing? Here is the code where i get the table...

record5.Source = "entrada_mt"
record5.CursorType = adOpenKeyset
record5.CursorLocation = adUseClient
record5.LockType = adLockOptimistic
record5.Open "SELECT * FROM entrada_mt", cn

i need to sum every record that has the same item code.... so i'll need conditions... thanks everyone!

strSQL = "SELECT SUM(FieldAmount) AS TheSum FROM MyTable WHERE FieldCriteria = " & SomeCondition

Good Luck