You can't really have subtotals in a query. You would need a report for that. In a query, you can see either the full list, sorted any way you like, or the subtotals, but without the details. For example, this shows you the two subtotals:
SELECT Sum(QFlow)
FROM tblMain
WHERE ID Between 9 And 15
GROUP BY [Group];
In a report, you can show all your columns, add a grouping on tblMain.Group, and request subtotals on any fields in the group's footer.
(°v°)
Main Topics
Browse All Topics





by: bobby6055Posted on 2009-11-07 at 19:20:01ID: 25769295
Attached is a sample db and a text file for the test
Download sample
Text File