Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Jan 2001
    Posts
    116
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Parameter Value Query (Access 2002)

    I have a simple Select Query with a number of fields based on one table and with just one calculated field using an IIf expression. No criteria are listed anywhere in the Query. Yet whenever I run the Query I get a dialogue box asking me to "Enter Parameter Value" in the field "nul". It doesn't matter if I put in something, anything, as a parameter or if I just leave it blank...the query runs as designed. How can I stop this box popping up each time I run the Query?

    Roger

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Parameter Value Query (Access 2002)

    Hi Roger,
    Does your IIf expression involve Nulls? It sounds as though there's a typo in it and you've got Nul instead of Null.
    Hope that helps.
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    2 Star Lounger
    Join Date
    Jan 2001
    Posts
    116
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Parameter Value Query (Access 2002)

    That was it...or nearly! Changing nul to null just resulted in a parameter query for null but changing it to "" fixed the problem. Thanks

Posting Permissions

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