sql – Calculating a Sum Value on a report in Access

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)

Or

 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

sql – Calculating a Sum Value on a report in Access

Leave a Reply

Your email address will not be published.