Function not found

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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)
Click to expand...

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]
 
Back
Top