type mis

[js]

Hi, I have one integer and string field, how to conver string to integer:
WHERE PID =ChartNum;

Error: Type mismatch in expression...

 

[Graham R Seach]

WHERE PID = CInt(ChartNum);

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia