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

 

[Darrylles]

Hiya,

Easiest way I feel:

Try exporting your Word document to an Excel spreadsheet.

Create a 'link table' to the 'Excel' spreadsheet called 2table (as per your example).
Do this by 'creating new' then selecting 'Link table'.

Create a query that compares the Access 1table to the 'Excel' link table (2table').

e.g:

select * from 2table where address1.2table like address1.1table

Remember that 'like' means exactly that - you may get more results than expected if you have multiple fields in the 2table that seem 'like' the criteria.

Regards,

Darrylle

"Never argue with an idiot, he'll bring you down to his level - then beat you with experience."