Query table join question

[Nelson8]

I was wondering if anyone knew how to run an access query that would allow me to join together the data from two tables below. I cannot access the database to create a new column that attempts to rid the second of an extra zero. The dataset is also too large for me to copy over currently. Any help would be greatly appreciated. Thank you.

Table 1
01
02
03
04




Table 2
001
002
003
004

[offie]

Are the numbers always 3 characters, and will you always just want the right 2? If so you can make a query and make a field Right([Table2].[Field],2), if you just want to get rid of the 0's make the field a numbers field (it's probably text right now). To change the type of a field look at http://office.microsoft.com/en-us/ac...001229018.aspx. When the numbers match then you can join them. Also if you wan to add a zero to Table1 you can make it "0" & [Table1].[Field]