nz

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

Guest

Hi: I have an Access query below. What does the nz mean in the first line?

SELECT [Sub1_EE Deductions].SSN, ([Sub1_EE
Deductions].[Deductions]-nz([Sub2_EE NonPayroll Items].[NonPayroll],0)) AS
Deductions
FROM [Sub1_EE Deductions] LEFT JOIN [Sub2_EE NonPayroll Items] ON [Sub1_EE
Deductions].SSN = [Sub2_EE NonPayroll Items].SSN;
 
This link may help.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/off2000/html/acfctNZ.asp

--
Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

:
| Hi: I have an Access query below. What does the nz mean in the first
line?
|
| SELECT [Sub1_EE Deductions].SSN, ([Sub1_EE
| Deductions].[Deductions]-nz([Sub2_EE NonPayroll Items].[NonPayroll],0)) AS
| Deductions
| FROM [Sub1_EE Deductions] LEFT JOIN [Sub2_EE NonPayroll Items] ON [Sub1_EE
| Deductions].SSN = [Sub2_EE NonPayroll Items].SSN;
|
 
Back
Top