comparing two memo fields

[niki]

Hello,
I have two distinct tables, from these tables I want to compare two fields containing text values (keywords) whose data type is memo.
they look like this:
RecID Value
1 tree
1 mountains
2 orange
...
1003 pluto
1003 saturn
1003 mercury
1003 earth

but, being a noobie to access programming, I don't know much about SQL programming...
I prefer for the moment learnig how to use VBA to define small codes, and use these in a query or a macro... That's what I did for all the prevous work I have done on this project.

So my questions is :
How could I compare my two tables for occurances of a same keyword in both tables? thx for your answer.
My goal is to obtain a resulting table containing fields for each matching keywords and its RecIds in the two tables where it is found...

regards,

nico

 

[wiltshire]

sounds like you just need to create a 'find duplicates' query from the wizard. This can be found by just clicking in queries and choosing 'new'

 

[dcx693]

Seems like you've been tackling a form of this problem for a while since you've posted some similar threads before here and here

In the case of this problem, the sample data you provided looks as if there is a keyword in the value field. Will each value field only have one keyword? Or could there be multiple keywords in each value field?

 

[niki]

Yep that's right I have been working on the problem for quite a long time and I have had other problems aside due to data formating. It's actually related to your question!! I neede to have each keyword in a separate field. now that its done there are still some compound words like post-synchronisation or equivalent.
If your question was intended to know if the match has to be case sensitive I'd say no. Because if I have "synchronisation" my second table, I want the match to work for "post-synchronisation".
Is that what you wanted to know?
thanks for your time
nico