Converting Numbers stored as text

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table in Access 2007 that contains an employee ID number and is set
to number. I need to link to another table in a different access database
that was designed by someone else. The other table has the employee ID
number but it is stored as text. How do I join the two tables so that I can
retreive data from both tables in a query.

Thanks for your Help,

Dan H. Hilyer
 
You can convert text to number as cint(ID) or clng(ID), but you will
have more luck converting number ot text (it won't drop zeroes) as
cstr(ID).

For Table (with number ID), create a query with a column that converts
the value, then join this new query to the table (with string ID).
 
Back
Top