Hi All

I know this might not make much sense, but I'm hoping you can help!

I have a table consisting of the following:

StudentID StudentName DOB
1 Fred 12-04-1996
2 Brad 01-11-1996
3 Gary 23-12-1996
4 Jill 16-01-1997

I need to do a query so that I get all of the students that have a birth
date that falls between 1 Sept - 31 Dec, 1 Jan - 31 Mar and 1 Apr - 31 Jul.

I tried to do a select StudentName, DOB from Students where day(DOB) & '-' &
month(DOB) > #01-09# and day(DOB) & '-' & month(DOB) < #31-12# order by 2,
but because I've not put a year it's getting everything between 1-9-the
first year to 31-12-the last year.

I need to get everybody between the specified sets irrespective what year
they come in.

Any ideas?

Thanks

Laphan

answered in microsoft.public.access thread with same Subject line.


"Laphan" <please (AT) dont (DOT) spam.com> wrote