query prompt for One or ALL months in database

[KAnderso]

I have a database with "Contact Dates". I want to write a criteria in my
query to prompt me to select a particular month/year or ALL of the
dates/months. How would I do this?

 

[KARL DEWEY]

[Enter month-year (11/1/2008)] OR [Enter month-year (11/1/2008)] Is Null

 

[KAnderso]

The Null piece works great; however, the first part, not so well. In my
table, I have Contact Dates (mm/dd/yyyy), I would like to run a query with a
prompt that would pull say Oct-2009 or ALL. Does this make sense?

Thanks for the help.
Kim

[Enter month-year (11/1/2008)] OR [Enter month-year (11/1/2008)] Is Null
--
Build a little, test a little.

I have a database with "Contact Dates". I want to write a criteria in my
query to prompt me to select a particular month/year or ALL of the
dates/months. How would I do this?

 

[KARL DEWEY]

Does your table have a Text or DateTime field?
If it is DateTime then try this --
WHERE Format([Contact Dates], "yyyymm") = [Enter year-month (200811)] OR
[Enter year-month (200811)] Is Null

Text field --
WHERE Right([Contact Dates], 4) & Right("0" & Val(Left[Contact Dates], 2)),
2) = [Enter year-month (200811)] OR [Enter year-month (200811)] Is Null


--
Build a little, test a little.

The Null piece works great; however, the first part, not so well. In my
table, I have Contact Dates (mm/dd/yyyy), I would like to run a query with a
prompt that would pull say Oct-2009 or ALL. Does this make sense?

Thanks for the help.
Kim

[Enter month-year (11/1/2008)] OR [Enter month-year (11/1/2008)] Is Null
--
Build a little, test a little.

I have a database with "Contact Dates". I want to write a criteria in my
query to prompt me to select a particular month/year or ALL of the
dates/months. How would I do this?

 

[KAnderso]

Karl,
Thank you...that did it (the first one - for DateTime Field)!

Kim

Does your table have a Text or DateTime field?
If it is DateTime then try this --
WHERE Format([Contact Dates], "yyyymm") = [Enter year-month (200811)] OR
[Enter year-month (200811)] Is Null

Text field --
WHERE Right([Contact Dates], 4) & Right("0" & Val(Left[Contact Dates], 2)),
2) = [Enter year-month (200811)] OR [Enter year-month (200811)] Is Null


--
Build a little, test a little.

The Null piece works great; however, the first part, not so well. In my
table, I have Contact Dates (mm/dd/yyyy), I would like to run a query with a
prompt that would pull say Oct-2009 or ALL. Does this make sense?

Thanks for the help.
Kim

[Enter month-year (11/1/2008)] OR [Enter month-year (11/1/2008)] Is Null
--
Build a little, test a little.


:

I have a database with "Contact Dates". I want to write a criteria in my
query to prompt me to select a particular month/year or ALL of the
dates/months. How would I do this?