Member Avatar for fernando82

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
record5.MoveFirst

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

  • 2 Contributors
  • 1 Reply
  • 67 Views
  • 13 Hours Discussion Span
  • Latest Post Latest Post by vb5prgrmr
Member Avatar for vb5prgrmr 
strSQL = "SELECT SUM(FieldAmount) AS TheSum FROM MyTable WHERE FieldCriteria = " & SomeCondition

Good Luck

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.