I have a table with a zip code field formatted as text. All zip codes in this table have 5 numbers. [no hyphen plus the addtional 4 numbers].
I had to link this zip code table to another table by zip code (formatted as text). The result is that I am only getting the zip codes that match the zip codes from the second table that have the 5 digits. Example - I am getting all the 12345 zipcodes but not the 12345-6789.
I appreciate your help. I just received my Microsoft Academic Course for Access 2007.
Laurie B.
New User