I am getting these errors every time I edit a calculated field when combining addition and multiplication. Can someone try the following to see if it is just me.
Runtime Error 216 at 00002E28
Runtime Error 216 at 00071F74
----------------------------------------------------
1. Create table “Test” with fields:
Field1 A 10
Num1 N
Num2 N
Num3 N
Result N
2. Create Report – New / Data Model - Select "Test.db"
3. Create a new undefined Result field Right-Click and select “Define Field”
4. Check “Calculated” and edit the entry box selecting fields to produce:
([test.num1]+[test.num2])*[test.num3]
5. Click OK (If report run now it will work, but...)
6. Go back to the same field and goto Define Field dialog box to edit the calculation. Click OK (whether you actually edit the calc or not)
7. Run the Report. What do you see?
------------------------------------------------------------------------------
Additionally, reports that include these types of calculations originally designed on a previous version will run fine until I try to edit the calculated field. By pressing the OK button, I will generate this error even without actually changing the calculated field.
Runtime Error 216 at 00002E28
Runtime Error 216 at 00071F74
----------------------------------------------------
1. Create table “Test” with fields:
Field1 A 10
Num1 N
Num2 N
Num3 N
Result N
2. Create Report – New / Data Model - Select "Test.db"
3. Create a new undefined Result field Right-Click and select “Define Field”
4. Check “Calculated” and edit the entry box selecting fields to produce:
([test.num1]+[test.num2])*[test.num3]
5. Click OK (If report run now it will work, but...)
6. Go back to the same field and goto Define Field dialog box to edit the calculation. Click OK (whether you actually edit the calc or not)
7. Run the Report. What do you see?
------------------------------------------------------------------------------
Additionally, reports that include these types of calculations originally designed on a previous version will run fine until I try to edit the calculated field. By pressing the OK button, I will generate this error even without actually changing the calculated field.