If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > PC based Database Applications > Microsoft Access > NZ function returns Error

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old
Registered User
 
Join Date: Apr 2004
Posts: 3
NZ function returns Error

I create a table called table1 with a column called test.

Then i create this query

SELECT nz([test]) AS Expr1
FROM Table1;

I get #Error on each row.

This problem is on a new XP system with Access 2003. I have uninstalled and reinstalled the program. I was notified of this bug by a client who is running a program that I have written and it is installed on over 1500 desktops, so I am pretty sure that it is something on this system.

Does anybody have any ideas.

BTW the left("test",1) returns a t so not all of the intrinsic function are failing, just NZ as far as I can tell.

Alternate searches have not turned up anything. I remember a problem where chr() did not work on asp pages beacuse of a version of vbajet32.dll
Reply With Quote
  #2 (permalink)  
Old
Purveyor of Discontent
 
Join Date: Mar 2003
Location: The Bottom of The Barrel
Posts: 6,102
You're missing an argument.

nz([test], ValueIfNull)
Reply With Quote
  #3 (permalink)  
Old
Registered User
 
Join Date: Apr 2004
Posts: 3
Quote:
Originally posted by Teddy
You're missing an argument.

nz([test], ValueIfNull)
Not true, The ValueIfNull is an optional value. The nz will return zero if the optional value is not given. This works on over 1500 desktops, just not this one . Thanks for the reply though. Any other ideas
Reply With Quote
  #4 (permalink)  
Old
Registered User
 
Join Date: Apr 2004
Posts: 3
I have fixed it by installing the Jet 4.0 service pack 8 and then setting macros security to Low.

Confusing but it works now.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On