I am trying to get the sum of a column with in a session when a user scans a barcode. The following is on a SQL variable field. Basically, when the index is entered of the item, I want to get the sum of a column for all references to the index.
SELECT SUM(Session6.Field14) FROM Session6 WHERE...