Calculation not working on report

[CS_10]

I have a report with quite a few fields on it.



I have a text field called Text56, and this pulls in a value from the Control Source. This works fine.

I have another field called Text1, this does the same.

I have added a third field and entered this in the control source: =([Text56]/[Text1])

However, when running the report, it asks me for the value of Text56, instead of using what is pulled through in to the Text56 field!!

I have several others like this which are working fine on my report, but this one won't work.

Can anyone think what might be causing it?

[JoeM]

Not sure, but if both Text56 and Text1 are fed by an underlying table or query, why not do the calculation in the query itself instead of directly on the report.
Whenever possible, I try to do most of my calculations in the underlying query. To me, it is much easier to manage.

[CS_10]

I see what your saying Joe, but its puzzling me how exactly the same fields are working on the same report for others.

The only difference is that I added the underlying data on to the query of the one I'm working on more recently than the others...

What could it be?

[CS_10]

How Bizarre,

I have since completely closed Access and reopened, and now it does it properly!!!

Its as though it needed a refresh after adding the fields to the query.!

However I have one other issue now.

I have a number of Text fields that return a percentage field based on a calculation in the control source.

I want to create a new field that displays a total of these percentages to make sure they add up to 100%.

However I am struggling.

In a text field, should this control source work:
=Sum([Text7]+[Text9]+[Text69]+[Text73])

At the minute when running the report, it is asking for the values of all 4 fields.

[aytee111]

When referring to an object, sometimes Access uses the Control Source name and sometimes the object (text box in this case) name. Best practice is to make both of these names the same, then you will not have to worry when one should be used and when the other.

[JoeM]

=Sum([Text7]+[Text9]+[Text69]+[Text73])

BTW, using the plus sign and SUM is redundant!
You don't need SUM if you are already adding the fields together.

[CS_10]

Cheers for the help everyone.