as i m using vb6 as front-end & access as back-end i want to replace the null value with any character or numeric by using nz i solve the problem but the same query does not execute from front-end it genrates error "UN defined function nz"