sql – Calculating a Sum Value on a report in Access
You can either use DSum or build your report query to include the calculation. I would prefer the second option. This assumes that SCID is numeric, you would need quotes for a text SCID.
=DSum(sValue,[Stock Conversion Items],SCID= & sSCID)
SELECT r.This,r.That,s.ConvValue FROM ReportTable r INNER JOIN ( SELECT SCID, Sum(sValue) As ConvValue FROM [Stock Conversion Items] GROUP BY SCID) s ON r.sSCID = s.SCID
The above query uses aliases r and s for the tables :
ReportTable r or
ReportTables As r