Page totals

[guldo76]

I have a query with, say, field1, field2, field3 and field4. [field3] is [field1]*[field2].
I have a report based on that query.
In the page-footer I put the sum of field2, subject to [field4]=0.1, for example, updated by a macro everytime the report is opened (print or printpreview). It's fine.
But if I try and put the totals for field3 (same constraint), it no longer works. Those textbox are just left blank.
How does it work?
Is it due to when the query is executed?
I mean, what's the order in which the query, the on-formatting and the print event are pocessed?
I suppose the query is processed first, but, if that's the case, why doesn't it work? Why does it work when the report-page-totals are based on freezed records of the query, but it doesn't when they're based on records that are calculated in the very query?
Any help?

Thanks,
Guldo

 

[dynamictiger]

Reports format known data first, in this event the query based data that is not calculated. Then they calculate although this is not clear, I think they calculate all fields at once. Hence a total of a calulated value will be left blank. Unless you total calculate.

TotalValue1 * TotalValue2 will work in the footer.

For interest then code is run.