"Calculations" -- could you clarify? Are the calculations in event code, or
an expression in the Control Source of a Control? Control Source expressions
can refer to a field in the Report's RecordSource. For example, you can use
the Sum or Count functions in the Control Source of a Control to total or
count in the Group or Report Footer -- it's very common.
Performing calculations in Report event code can be problematic because the
events may fire more than once for a record, even just going forward. They
may fire quite a number of times in Report Preview, as you scroll forward
and backward. That is why calculations must be very, very carefully done, or
avoided in the Format and Print events.
Larry Linson
Microsoft Access MVP
Larry Linson
Microsoft Access MVP
"John M" <jo**@jmawer.demon.co.uk> wrote in message
news:ck*******************@news.demon.co.uk...
Hi,
I've been coming up against a failure of a report to display the result of
a simple calculation. I have realised that this calculation cannot take
place unless the field I am working on is displayed or is some way referred to
in the report. am I right in this? It seems odd if the field is there in
the underlying query.
Is this right? Is there a way round?