W
WembleyBear
This should be easy but I'm having a problem with it.
I have a query which returns a list of address from the Targets table. One
of the fields holds the UK postcode, eg LU10 1NN, PE17 1DP.
Another table called Area holds the first part of the postcode ranges which
fall into our sales area, eg LU9, LU10, PE17 etc
What I want is for the query to return only records in our sales area (i.e.
records whose postcodes start with one of the postcode areas from the Area
table Ordinarily, I could just do Like "LU10*" to return all postcodes that
begin with LU10 etc if there were only a couple. But there's over 200.
What's the best way of doing this?
Martyn
I have a query which returns a list of address from the Targets table. One
of the fields holds the UK postcode, eg LU10 1NN, PE17 1DP.
Another table called Area holds the first part of the postcode ranges which
fall into our sales area, eg LU9, LU10, PE17 etc
What I want is for the query to return only records in our sales area (i.e.
records whose postcodes start with one of the postcode areas from the Area
table Ordinarily, I could just do Like "LU10*" to return all postcodes that
begin with LU10 etc if there were only a couple. But there's over 200.
What's the best way of doing this?
Martyn