SQL for Weighted Survey Results
SELECT TOP 100 PERCENT dbo.tblESSurveyW1Demo.CQ30, SUM(dbo.tblESSurveyW1Weight.weight_bb) AS WeightedCount, COUNT(dbo.tblESSurveyW1Weight.RESPID) AS UnWeighted FROM dbo.tblESSurveyW1Weight INNER JOIN dbo.tblESSurveyW1Demo ON dbo.tblESSurveyW1Weight.RESPID = dbo.tblESSurveyW1Demo.RESPID GROUP BY dbo.tblESSurveyW1Demo.CQ30 ORDER BY dbo.tblESSurveyW1Demo.CQ30