formula/table that searches and links

[Frans]

I would like to create a table that has (takes) one (unique) value from one table and find this value in another table (as part of a text field with much more information).


In excel I used a formula that was a combination of search end lookup.

LOOKUP(1,1/(SEARCH(Q17,'AA mutaties'!$H:$H))

I've recently started with Access and do not understand how to do this in Access.

The second thing is that the unique value does not always exist in the other table. In that case there are two other fields that can be used and lookup for in the other table. If these two values both have a match in the other table it's quite sure the match is correct.

Anyone any ideas how to realise this?

Thanks!

[ranman256]

In Access you open a query to do the 'lookup' to get your answer.

Build queries to do all your various 'lookups'.