Using CR10 and SQL Server db. I have a table that has City State Zipcode and I have another table that has State Zip_Start and Zip_End with an Identification Field. I am trying to match Table 1 using State and Zipcode and return the ID field from Table 2. My problem is that linking to stat is fine but if the zipcode falls in between the start and end I cant get it to come out correctly. The NY is an example of this:
Table 1
State Zip
MI 48009
NC 27612
NC 27150
IN 46240
Table 2
STATE ZIP_START ZIP_END IDField
GA D
NM B
NY 12000 14999 A
NY F
NY 10000 10499 A
OH 45000 45299 G
OK E
TX C
Any insight on how to resolve this would be great. Thanks
Table 1
State Zip
MI 48009
NC 27612
NC 27150
IN 46240
Table 2
STATE ZIP_START ZIP_END IDField
GA D
NM B
NY 12000 14999 A
NY F
NY 10000 10499 A
OH 45000 45299 G
OK E
TX C
Any insight on how to resolve this would be great. Thanks