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.
Above is what I am using. The session I am performing this in is also session 6. Can I do this? I set the field to a static number for testing purposes.
SELECT SUM(Session6.Field14) FROM Session6 WHERE Session6.Field8='999'