let try harder !!!

[FROGGY01]

dear all

i have a table with an adress field
and an another with word
the question is how can i match them

example

1 table
field adress:
- abbey road
- sunset BVD

2table
field word and field adress
- abbey 1
- rd 1
- sunset 2



thanks

ps : i don't want a solution whith a fusion of abbey and rd

 

[hermanlaksko]

You can match the 2 if you can find something unique in the 2 i.e. in table 2 you have abbey and in table 1 you have left(adress, instr(1,Adress, " &quot-1)=abbey so a match