a personal request (between two given dates)

[ramesh]

hi friends

assume that there is table called BIRTHDAY which has two fields
empid (datatype as text) and dates (data type as date/time)

there are two records in that like as follows

2000001 12/05/1948
2000444 28/05/1984
2000448 01/05/1976

now given two dates as 1/5/2002 and 31/5/2002

i need to write a query where i should get the above records.
note : both dates inclusive

can anyone write a query ... as it very important for me.

 

[Rich]

I am certain that an extensive answer on this question has been posted recently, if you enter Birthday in the search facility here I'm sure you'll find it. Post back for further help.

 

[ramesh]

i am not able to get query... what i wanted is not there.


please can u send me the query..

ramesh

 

[Fizzio]

See Here
http://www.access-programmers.co.uk/ubb/Forum3/HTML/003728.html