query problems

Results 1 to 3 of 3

Thread: query problems

  1. #1
    Join Date
    Dec 1969

    Default query problems

    I have one query using mutiple subqueries where I have to summarize, some of these fields may be &#039;NULL&#039;. I used the function Nz(access) to overcome this problem. It works fine in the database itself but when i call the query from an asp page I get the following printout. Can someone help me.<BR>Thanks in advance<BR><BR>Error Type:<BR>Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)<BR>[Microsoft][ODBC Microsoft Access Driver] Undefined function &#039;Nz&#039; in expression.<BR>

  2. #2
    Join Date
    Dec 1969

    Default It is not a in built function..

    right? You wrote it.<BR><BR>If you can show us the query, we will get better picture of the problem.

  3. #3
    Join Date
    Dec 1969

    Default RE: query problems

    iif(c1 is null,0,c1) would be the same as nz(c1,0)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts