I have three calculated fields in a form. As far as I know, they are completely sound. And, in fact, they work perfectly fine on every copy of the front end except mine (everyone at work copies and pastes the same version of the front end to their desktops and links it to a common back end on a server). Instead of getting numbers, I get the #Name? error on each field. This happens for every single record.

Age: =(Date()-[DOB])/365
Age at extension*: =[Current_age]+([real_extension]/12)
Ext LE over pricing LE* = [Real_extension]/[Average_le_used]-1

All of the fields referenced are also in the form and the query underlying it. Again, this works perfectly fine for everyone except me, even though our copies are exactly the same.

1. Basically, why would this not work for me when my version is an exact copy, and every other copy works?
2. What other information do you need to know to think about this?

Best,


Robert