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.

 

[arnelgp]

you may try to cast your formula in IsError() or IsNull() function.

 

[Ken Sheridan]

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

The attached file illustrates the use of three functions for returning the accounting year, the date of the start of the accounting year, and the quarter of the accounting year, on the basis of the date passed into the function as an optional argument. If no date is passed into the functions their return values will be on the basis of the current date.

To return the month of any date the Format function will do this. You can see how it works in the immediate window:

? Format(#2026-02-16#,"mmmm")
February
? Format(#2026-02-16#,"mmm")
Feb
? Format(#2026-02-16#,"mm")
02
? Format(#2026-02-16#,"m")
2