1 Attachment(s)
[Resolved] How to place a Total in a Report?
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.
Re: How to place a Total in a Report?
Im not sure if this as what u want..
create Formula Field name and write a formula in Formula Editor
sum({tblPO.SubTot})
Place this Formula Field name on your form.
Re: How to place a Total in a Report?
So, I will add a Formula (instead of Total) beside ItemNo, PONO, SubTot? But where is the Formula Editor? I can't see it on MS Access nor on the DataReport itself. Pardon my ignorance. :D
Re: How to place a Total in a Report?
Moved to Reporting Section
Re: How to place a Total in a Report?
I figured it out. I just need to add an Add(Field) Function at the report footer. :D