VB6 DAO Searching Access DB Within Limits

Hi guys.

I am using VB6 and I have a Access Database. I am using DAO, I have used it before and would prefer to stick to it.

In the database I have a column of numbers and I want to search that column within a set a limits, for example search for all records between 1.5 and 1.85. Is this possible.

Thanks!

You need to execute sql similar to this when you open recordset:

select * from Limits where limit between 1,5 and 1.85