[Resolved] How to place a Total in a Report?

[sirkeled]

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.

[zombiee79]

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.

[sirkeled]

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.

[Hack]

Moved to Reporting Section

[sirkeled]

I figured it out. I just need to add an Add(Field) Function at the report footer.