View Single Post
  #1  
Old May 12th, 2010, 08:43 PM posted to microsoft.public.access.queries
Chrissy
external usenet poster
 
Posts: 93
Default Query and date selection

I test to see if a reservation begins between 11/15-3/31 of any year.

So far I have come up with, for the reservation begin date:

Between #11/15/2009# And #12/31/2009# Or Between #1/1/2009# And #3/31/2009#

This, of course, only tests for 2009. Can I use a year wildcard? Is there
a better way?

Thanks in advance,
--
Chrissy