K
KateB
Has anyone else encountered this problem? I've created a recordset from a
table. Some of the fields in the table are numeric. After creating the
recordset with an SQL I try to retrieve the values of the columns by
rs!Metrics & ""
rs![Date_ID]
The error occurs on the rs![Date_ID] because it cannot find this in the
recordset. However, Date_ID evaluates to 200445. Substituting in
rs![200445] gives the correct value with no error.
table. Some of the fields in the table are numeric. After creating the
recordset with an SQL I try to retrieve the values of the columns by
rs!Metrics & ""
rs![Date_ID]
The error occurs on the rs![Date_ID] because it cannot find this in the
recordset. However, Date_ID evaluates to 200445. Substituting in
rs![200445] gives the correct value with no error.