F to C conversion formula?

[June7]

I inherited a db with table names starting with numbers. Access query builder has no problem with it but I found VBA was persnickety about this.

For instance, the syntax of



Debug.Print rs!1Fld

gets modified by VBA to

Debug.Print rs!; 1; fld

adding parens handles this idiosyncrasy.

Debug.Print rs![1Fld]

as does

Debug.Print rs("1Fld")

[ArviLaanemets]

Ignore this! There was a field TempF!

...To learn, I tried to change the now working formula to remove the brackets (TempF-32)*5/9 but that didn't work. ...

"-" is one of special character meant before, So either use [TempF-32], or rename the field as e.g. TempF32.

I suspect poor Access tried to substract 32 from TempF, and didn't find such variable.