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
|