How to compare a number field and a text field

[Laurie]

I have two tables that I need to compare the data. In one
table the field is a text field even though it has a
single digit number in it. The other table has the data
as a number field. How can I convert one field inside a
query so that I can compare the fields to one another
without a datatype mismatch?

Thank you.

Laurie

 

[Van T. Dinh]

Use one of the VBA Conversion functions: Val(), CByte(),
CInt(), Clng().

Check Access VB Help on these functions.

HTH
Van T. Dinh
MVP (Access)