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).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Form/subform worries 2007 1
Payroll Database - Need Help!! 1
storing historical data in Access 1
Special characters 3
text conversion to number on select query 5
update table using a Query 3
Combo box & Search Function 3
Getting another employee's data from the Employee table, and text innumber fields 3

Back
Top