View Single Post
  #3  
Old May 12th, 2010, 09:01 PM posted to microsoft.public.access.queries
vanderghast
external usenet poster
 
Posts: 593
Default Query and date selection

You can try a criteria under beginDate:

DateSerial( Year(beginDate), 4, 1) OR DateSerial( Year(beginDate),
11, 15)


Vanderghast, Access MVP


"Chrissy" wrote in message
...
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