Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Posts
    8

    Unanswered: Multiple variables in query, some null

    I need help with the last part of this query design. I am trying to use a form to create a custom report. I want to be able to use multiple textboxes as my controls and if they are left blank, all records are selected. I can make that work for on textbox, but not all of them at the same time. Please take a look and see where the solution is as I have a hard time explaining the issue. I have attached an example database (Access 97).
    Attached Files Attached Files

  2. #2
    Join Date
    Oct 2003
    Location
    US
    Posts
    343

    Re: Multiple variables in query, some null

    Here you go.. !!!!

    Originally posted by pablotx
    I need help with the last part of this query design. I am trying to use a form to create a custom report. I want to be able to use multiple textboxes as my controls and if they are left blank, all records are selected. I can make that work for on textbox, but not all of them at the same time. Please take a look and see where the solution is as I have a hard time explaining the issue. I have attached an example database (Access 97).
    Attached Files Attached Files

Posting Permissions

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