>Hi everyone, I'm a new programer in VB, I have 5 years programming in VFP and now I'm trying to understand this another tool, so I'm experimenting some troubles on it.
>
>I'm trying to create an ADO Recordset and when I want to assign it source property I put an SQL Statement like this:
>
>"Select * from mytable where mytable.code = " & strcode & " and mytable.year & mytable.month >= intYear & intMonth"
>
>When I say: myrecordset.open, VB send me an error message like:
>
>"THE ODBC CONTROLLER DOESN´T HAVE SUPPORT TO THIS PROPERTIES"
>
>In fact, I only want to know how can I obtain a set of records if Ii give to the SQL Statement a range of dates.

Can you show us more complete code?