I'm very puzzled:
The SQR() function is used in ACCESS SQL queries in a db I've inherited. These have been working up until last Wednesday. The db gets used twice a week, Wed and Fri.
The queries now report a compile error. Any suggestions would be greatly appreciated.
Here is a simple example that illustrates the problem:
Created a table TEST with one field [BASENUMBER] as an Integer.
Added rows of data: 1, 2, 3, 4, 5
This SQL query works:
SELECT TEST.[BASENUMBER] as X, [X]*[X] as X2
FROM TEST;
X X2 1 1 2 4 3 9 4 16 5 25
This query, representative of the type of calculations, does not:
SELECT TEST.[BASENUMBER] as X,
[X]*[X] as X2,
SQR([X2]) as FSQR
FROM TEST;
It returns: Compile error. in query expression 'SQR([X2]'.
And nor does this
SELECT TEST.[BASENUMBER], SQR(TEST.[BASENUMBER]) as FSQR FROM TEST;
The machine is running Windows 10 Home 10.0.15063 Build 15063
Access 2010 32 bit as part of Microsoft Office 2010