Hi

I Am Using Access2000 Database.

Query
------
Select Gen.glname As Glname, Gen.groupc As Groupc, Gen.opbal As Opamt, Sum(txn.amount) As Txnamt, (opamt+nz(txnamt,0)) As Clbal
From Gen Left Join Txn On Gen.glcode=txn.glcode
Group By Gen.glname, Gen.opbal, Gen.groupc;

While Calling This Query In Crystal Error Message Shown -

Odbc Error: [microsoft][odbc Microsoft Access Driver ]
Undefined Function 'nz' In Expression.


Pls Help How To Overcome From This Problem.


Thanks

Asm