guery relationship

[Jason Frazer]

I'm trying to create a query.
I want the relationship between the two tables to be the
zip code. The only problem is that the table [customers]
uses a zip code like this "12345-6789" and the table [tax]
uses a sip code like this "12345". How can i have a
relationship to just look at the first 5 digits.

Thanks for your time and help

Jason frazer

 

[Jim/Chris]

First create a query which trims the left 5 positions off
the zip code in the one table. Use this query as input to
your query for the that table.

Jim