How to compare a number field and a text field

  • Thread starter Thread starter Laurie
  • Start date Start date
L

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
 
Use one of the VBA Conversion functions: Val(), CByte(),
CInt(), Clng().

Check Access VB Help on these functions.

HTH
Van T. Dinh
MVP (Access)
 
Back
Top