Function not found

[Guest]

I have an access query where I use the Nz function. The function works fine
on Access 2003 (ver 11.5614.5606) but on ver (11.6355.6408) I get a "function
not found" message when I try to run the following formula on a query
Bal: Nz(([onh]), 0) - Nz([q1]), 0)
I even tried to pre-populate the field with zero's when creating the table.
still no luck. The query gives a type mismatch. The fields are
numeric...onh is a long int and Q1 is a double.
this is driving me nutz!
BTW, this table is created with a create query.

 

[Guest]

I believe it is a syntax problem. Try:
Bal: Nz([onh], 0) - Nz([q1], 0)

 

[John Vinson]

I have an access query where I use the Nz function. The function works fine
on Access 2003 (ver 11.5614.5606) but on ver (11.6355.6408) I get a "function
not found" message when I try to run the following formula on a query
Bal: Nz(([onh]), 0) - Nz([q1]), 0)

This appears to be the very common References bug. Open any
module in design view, or open the VBA editor by typing
Ctrl-G. Select Tools... References from the menu. One of the
..DLL files required by Access will probably be marked
MISSING. Uncheck it, recheck it, close and open Access.

If none are MISSING, check any reference; close and open
Access; then uncheck it again. This will force Access to
relink the libraries.

John W. Vinson[MVP]