Help! I need to pull out all of the birthdays in a school term

[Laphan]

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

 

[tina]

well, you're not doing any partial months, so i'd forget days altogether.
you can add a calculated field to the query, as

BDMonth: Month(DOB)

set criteria on the calculated field, as

<4

for Jan - Mar,

Between 4 and 7

for Apr - Jul, and

Between 9 and 12

for Sep - Dec.

hth

 

[Laphan]

tina you're a gem!!!

My brain ain't working at the optimum speed at the mo!!

Thanks again

well, you're not doing any partial months, so i'd forget days altogether.
you can add a calculated field to the query, as

BDMonth: Month(DOB)

set criteria on the calculated field, as

<4

for Jan - Mar,

Between 4 and 7

for Apr - Jul, and

Between 9 and 12

for Sep - Dec.

hth

 

[tina]

you're welcome

tina you're a gem!!!

My brain ain't working at the optimum speed at the mo!!

Thanks again

well, you're not doing any partial months, so i'd forget days altogether.
you can add a calculated field to the query, as

BDMonth: Month(DOB)

set criteria on the calculated field, as

<4

for Jan - Mar,

Between 4 and 7

for Apr - Jul, and

Between 9 and 12

for Sep - Dec.

hth


'-'