Dear Friends,

RyanRandall is correct my problem is with the data in the table

the format of the date in the table is a mixture of mm/dd/yyyy and mm/dd/yy format.

IsDate(DOb)=0  returned  many  records.

Thanks for...

Thanks for your reply....

I tried using cast and convert but did't  work.

Thanks for your reply..

My table contains about 65 fields so is there any other way to solve my problem.

Thanks

Dear Corie,

I have provided 3 levels of security for my application through front end and it's working perfectly but if any of the user of my app has installed Sql...