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!
Re: VB6 DAO Searching Access DB Within Limits
You need to execute sql similar to this when you open recordset:
select * from Limits where limit between 1,5 and 1.85