G Guest Jan 25, 2004 #1 I am trying to make a query that searches Title Fields in two separate tables for possible matches. Does anyone know of any way to do this?
I am trying to make a query that searches Title Fields in two separate tables for possible matches. Does anyone know of any way to do this?
J John Spencer (MVP) Jan 25, 2004 #2 Can you expand your question a bit? Do you want to compare the title fields in table A to Table B and if they exist in both tables, display Table A records? Do you want to look for a word (or words) in the title field of both Table A and Table B and return all the records in both tables? Do you want to look for approximate matches between the two tables? -- This can be really, really tough to do depending on how you define approximate? Is there some field in Table A that matches the data in a field in Table B? Hopefully, if you can expand your question with some details (or a couple of specific examples) then someone can give you an answer.
Can you expand your question a bit? Do you want to compare the title fields in table A to Table B and if they exist in both tables, display Table A records? Do you want to look for a word (or words) in the title field of both Table A and Table B and return all the records in both tables? Do you want to look for approximate matches between the two tables? -- This can be really, really tough to do depending on how you define approximate? Is there some field in Table A that matches the data in a field in Table B? Hopefully, if you can expand your question with some details (or a couple of specific examples) then someone can give you an answer.
