assuming you have two date variables.. startDate and endDate..
WHERE (day > #day(startDate)#)
AND (month > #month(startDate)#)
AND (day < #day(endDate)#)
AND (month < #month(endDate)#)
Mike Kear wrote:
> I have a database containing a list of events (birthdays,
> anniversaries etc), and
I have a database containing a list of events (birthdays,
anniversaries etc), and want to produce a listing of the events
relating to this week, this month, today etc as the user requests on
the form I give them.
Because not everyone's birth year is known, not all the birthdays have
a year. they
2 matches
Mail list logo
