Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2004
    Posts
    2

    Unanswered: Data Access Page - Parameter Query

    I've given up trying to figure this out!!

    I'm trying to run a parameter query for every record that lies between 2 dates. I can do that bit no problem.

    But I need the query to return all records if they are left blank.

    There is a sample bit of code out there that uses the Nz function but when the query is run through a DAP I get:

    'undefined funcion 'Nz' in expression'

    The field i am trying to run the query off is:
    Main_Data.Date_Raised

    This is what i tried with the Nz function:

    WHERE (((Main_Data.Date_Raised)>=(Nz([Enter Start Date - Blank for First],#1/1/1901#)) And (Main_Data.Date_Raised)<=(Nz([Enter Finish Date - Blank for Last],#12/31/2999#)))

    Cheers in advance

  2. #2
    Join Date
    Mar 2004
    Location
    belgium
    Posts
    290
    as far as i know the Nz function act on variables of the Variant type.

  3. #3
    Join Date
    Aug 2004
    Posts
    2
    Should i be using the IIf function or is there something obvious i'm missing?

Posting Permissions

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