guery relationship

  • Thread starter Thread starter Jason Frazer
  • Start date Start date
J

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
 
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
 
Back
Top