Jegajothy vythilingam
asked on
Access 2007 Nz Function
My OS is Win exp prof and I use Access 2007 from time to time. i have come across this Nz function a number of times, but have no idea what it is for or what it does. Can any of Gurus give me a simple explanation. thank u.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
matthewspatrick,
Feel free to "Clarify" (the nice way of saying "Correct") anything I have stated above...
;-)
Jeff
Feel free to "Clarify" (the nice way of saying "Correct") anything I have stated above...
;-)
Jeff
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thank u to everyone who contributed.
Jeff,I see nothing to "clarify" except your arithmetic on the average :)I have no idea what the analogous function(s) would be in Oracle's PL/SQL.In SQL Server's T-SQL, I usually rely on COALESCE, which is even handier than Nz: I can pass any number of arguments to COALESCE, and it returns the first non-null value it finds (or null if every single one is null). The T-SQL function that comes closest to Nz is IFNULL; it works exactly the same way Nz does. T-SQL does not have an IIf function, although it does exist in MDX and Reporting Services, and if you use ActiveX scripting in DTS, VBScript implements the IIf function. (Since I am a .Net ignoramus, I have no idea about SSIS. My "Master" cert in VB.Net is a testament to the wonders of cross-posted questions.)For MySQL...my "Master" cert in that zone notwithstanding, I really do not know. That cert is another artifact of cross-posting :)Patrick
Thanks Jim and Pat.
Yes Pat, the same goes for me, I only posted those as things I saw that could be substituted for NZ()
I'll send you an email about that average though...
Jeff
Yes Pat, the same goes for me, I only posted those as things I saw that could be substituted for NZ()
I'll send you an email about that average though...
Jeff
The average of:
2,4,6,0,8, 23, and 10, ...is 7.57
(I think...)
;-)
Jeff