Value to calculated control

  • Thread starter Thread starter ANDERS FLODERUS
  • Start date Start date
A

ANDERS FLODERUS

I am new to Access and I have a problem I do not know how to
handle. I have a calculated control and I want it to show the
following value (fetching values Number and Price from
table columns):

=Sum([Report]!Number*[Price])

but when I do, it can not find Number but asks me to give it manually.

However, the following expressions work OK:

=Sum([Price]) Sums the Prices OK
=[Report]!Number Gives Number from first row OK
=[Price] Gives Price from first row OK

while

=Sum([Report]!Number) Gives the same error as the original

I have tried some different embellishments, probably not all
possible ([Report]! is what I get when fetching the name from
the Expression Builder), they all give the same error.

I am using the swedish version of Access, I hope my translation
back to english does not mess things up.

Thank you for any response

Anders Floderus
 
In the Detail section of your report, you could make a calculated field like
this:
=[Number] * [Price]

However, if you want to sum the total price, you are probably better using a
calculated field in a query.

1. Create a query into your table.

2. In a fresh column of the Field row, enter:
Amount: [Number] * [Price]

3. In your report, place a text box in the Report Footer section bound to
the Amount field.

Please note that you cannot use the Page Footer section.
 
Back
Top