Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Posts
    100

    Unanswered: Parameter Query pulling from Form

    I've been trying to get a parameter query to pull info from a form (from a textbox) and it works fine. However, when I want the textbox to be BLANK it doesn't work! I've tried using "" as well as Null and * but it screens on this and my query pulls up nothing.

    Thanks for the help!

    Norm

  2. #2
    Join Date
    Dec 2003
    Posts
    10

    Re: Parameter Query pulling from Form

    Originally posted by norm801
    I've been trying to get a parameter query to pull info from a form (from a textbox) and it works fine. However, when I want the textbox to be BLANK it doesn't work! I've tried using "" as well as Null and * but it screens on this and my query pulls up nothing.

    Thanks for the help!

    Norm
    Have you tried:

    WHERE [name of textbox] LIKE 'NULL'

    or the oposite

    WHERE [name of textbox] NOT LIKE 'NULL'
    - Morty

  3. #3
    Join Date
    Jan 2004
    Posts
    100

    Re: Parameter Query pulling from Form

    Originally posted by morty
    Have you tried:

    WHERE [name of textbox] LIKE 'NULL'

    or the oposite

    WHERE [name of textbox] NOT LIKE 'NULL'
    I am using query builder to state:

    WHERE [forms]![monthlyrevenue]![billable]

    The field the textbox is reading from either says 'Billable' or 'Non-Billable' and I would like to either call up either ONLY BILLABLE or ALL accounts. So, as a newbie, I'm not sure how I would implement your suggestion.

Posting Permissions

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