SQR() function stopped working

[wjyoung]

Hello,

I have a report with a text box with the following formula:

=Sqr([Qty])*[Items_1.Weight SD]

You might recognize what I am doing here. If you know the standard deviation for a parameter of a single item, you can find the SD for multiples of that item by multiplying by the square root of that quantity.

Anyway, this function stopped working out of the blue. When I run the report I see #Name? on every page of Details without exception. When I try to edit the formula in design view, I get a compile error:

There was an error compiling this function.
The Visual Basic module contains a syntax error.
Check the code, and then recompile it.

When I remove Sqr([Qty]), the errors go away, so I've isolated the problem to that function. The data type of the Qty field is Number, size is Double.

Has anyone ever seen anything like this? Any ideas?

 

[wjyoung]

Update: I worked around the sqr() problem by raising to the 1/2 power. However, I just encountered a similar error on a LEFT() function. I'm beginning to worry I have a virus.