Cannot find the source code for the calculations marked in red

[access2010]

I am preparing to upgrade our Access 2003 and cannot find where to change the “Calculated Controls” for the red items in our report as the Ontario Sales Tax is no longer required.

Also, how do I insert the month and fiscal year into our reports?

Any suggestions would be appreciated.

Frida

 

[bob fitz]

I believe the calculations are achieved by using expressions in the Control Source property of the controls (text boxes).

 

[GPGeorge]

Although the color looks more pink than red to me, it is the case that the calculations are done as Bob indicates.

 

[mike60smart]

I am preparing to upgrade our Access 2003 and cannot find where to change the “Calculated Controls” for the red items in our report as the Ontario Sales Tax is no longer required.

Also, how do I insert the month and fiscal year into our reports?

Any suggestions would be appreciated.

Frida

Hi Frida

You have a problem with your relationships between tables.

If you try to link and Enforce Referencial Integrity between the Autonumber PK named Counter in your Customers Table to the related FK field Customers_ID in the table c_Customer_Invoice , you get the error message as shown in the attached screenshot.