I have a table (tblPO) which contains these fields:
1. ItemNo
2. PONo
3. SubTot
Now, I have a query that states:
SELECT Sum([subtot]) AS Total
FROM tblPO;
The thing is, I don't know how to combine it with the aforementioned 3 (ItemNo, PONO, SubTot) and how to display only one Total in the report.
What I like as a result would be on the attached image. Any suggestions would be appreciated. Thanks.




Reply With Quote