Thanx a lot Sean and Glenn, it works
One more ques:
what if i need all the records by date field????
e.g . if i need all the records with date > 1/1/99...
then what would SQL be like....

Select * from Details where date > "1/1/99"

this one above doesn't works........
if u know how, please let me know.....
thanx again for ur time...
Raj