Hello Access Experts,
as a new member to this forum please allow me to post a simple yet a bit problematic case. I have a query that uses a couple of fields from a form in order to find potential duplicates inside an underlying table.
How to properly write an sql Where condition inside a Select for this query so that I have such LIKE working:
(
[Table_1].[First_name]) Like ([Forms]![Form_1]![First_name]) - does not work as usual 'LIKE' but rather as ' = '
or better something like this:
(
[Table_1].[First_name]) Like '* ([Forms]![Form_1]![First_name]) *' - obviously does not work at all, but I need a LIKE condition that would work in a way that when I type e.g. 'ROG' in [Form_1]![First_name] it will search in
[Table_1].[First_name] for any combination of it and return e.g. ROGER, ROGER and MARY, FAROG, etc.
Please kindly advise how to properly reflect that in a query.
Thank you in advance!
as a new member to this forum please allow me to post a simple yet a bit problematic case. I have a query that uses a couple of fields from a form in order to find potential duplicates inside an underlying table.
How to properly write an sql Where condition inside a Select for this query so that I have such LIKE working:
(
[Table_1].[First_name]) Like ([Forms]![Form_1]![First_name]) - does not work as usual 'LIKE' but rather as ' = '
or better something like this:
(
[Table_1].[First_name]) Like '* ([Forms]![Form_1]![First_name]) *' - obviously does not work at all, but I need a LIKE condition that would work in a way that when I type e.g. 'ROG' in [Form_1]![First_name] it will search in
[Table_1].[First_name] for any combination of it and return e.g. ROGER, ROGER and MARY, FAROG, etc.
Please kindly advise how to properly reflect that in a query.
Thank you in advance!
Last edited: