Calculations in reports

[John M]

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?

[Larry Linson]

"Calculatio ns" -- 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.de mon.co.uk> wrote in message
news:ck******** ***********@new s.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?

[Salad]

John M wrote:

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?

Let's say your query has a field called Price. If you don't drop Price
onto the report, and attempt to reference it in a calc, you'll get an error.

So you can drop Price onto the report and make the Visible property = No.

Let's say you create a text box that is to display 10% of the price.
You would enter
=[Price] * .1

[gus kernot]

With the exception of column totals I normally do my calcs in the query.

It keeps the report simple.

gus

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!