I'm accessing a MS SQL table and assigning its records to variables.
It goes something like this:

MyVar = 0

Var2 = Recordset1("Field1") 'Field1 is numeric

MyVar = MyVar + Var2

The browser reports: 'data type mismatch'
When I debug in Interdev, I notice that MyVar's type is integer and Var2's type is Variant. How do I get around this? The table contains mostly numeric data fields.

I would really appreciate it if anyone can help me on this since I'm new at Visual Interdev and MS SQL.

Thanks