help me urgently the date problem....

[ramesh]

hi friends
i did not get the query
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/06/1976

now given two dates as 12/5/2002 and 31/7/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.


thanks

 

[Fizzio]

See here for the original post
http://www.access-programmers.co.uk/ubb/Forum3/HTML/003728.html