Re: Date Parameter

Melissa,

You could create a form that has a combo box on it that has "Is NULL" and "Is not NULL" as 2 options in it. Then you could set up
your criteria in your query to reference that combo box. In the criteria you would enter:

[forms]![Name of Form]![Name of Combo Box]

When you run this query, make sure the form is open (it can be hidden though). You should be able to put a button on this form that
will run your query for you.

I hope this helps,

Conan Kelly



"Melissa" <Melissa@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:BB1C12C0-39D5-47F8-B733-46FE85C20014@xxxxxxxxxxxxxxxx
I would like to have the option of choosing null or not null - by not
creating 2 queries. I had to ask - thanks
--
Access Novice


"Rick B" wrote:

Why would you not put that in the criteria? That is the way to do it.



--
Rick B



"Melissa" <Melissa@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:30CFEDA2-C1C0-4204-A97E-5C3715EDE957@xxxxxxxxxxxxxxxx
I understand that to use a date parameter you must use Between....
But is there a way to set a parameter that allows you the option of
selecting null or not null dates without put "null" of "Is Not Null" in
the
criteria?
--
Access Novice





.