This is the result of a query that's been used as the record source of a report :
How can I calculate the total and print it in the header?
The result should be :
(30 * 1,000) + (50 * 500) = 30,000 + 25,000 = 55,000
Thanks for any kind of help.
Edit: the query is not a saved query. I built the sql in vba, open the query and set the sql as its record source.
OrderPK | PartName | Treatment | OrderedOn | OrderedBy | Quantity | UnitPrice |
12032 | Test1 | N7 | 2021/02/22 | 2 | 30 | 1,000 |
11080 | Test2 | PL1-17 | 2021/03/12 | 2 | 50 | 500 |
How can I calculate the total and print it in the header?
The result should be :
(30 * 1,000) + (50 * 500) = 30,000 + 25,000 = 55,000
Thanks for any kind of help.
Edit: the query is not a saved query. I built the sql in vba, open the query and set the sql as its record source.
Last edited: