Database & Date

[mushahideen]

I have 2 fields in my access database namely

date_from and date_to.

Now I am getting two dates in intervels from the user, for example;

27/02/2002 to 05/03/2002.

Now I want to check whether any one of the date between the above mentioned dates are exists between the date_from and date_to in the database. Please help me to search with Database. I am using Simple Data Control.

[vbgladiator]

Can you not use the filter property?

DataControl.Filter = "Date_From >= " #27/02/02# & " AND Date_To <= " & #05/03/02#