E
e_marquess
This should be simple but it has me stumped.
I have two fields First_Name and Last_Name. I want to search for John
Smith by entering "John", "Smith" or "John Smith". I have tried to
concatenate the fields with this code and it works with "John" and
"Smith" but comes up blank when I enter "John Smith".
SELECT First_Name, Last_Name FROM ASPP_Users WHERE (First_Name + ' ' +
Last_Name) Like'%" + Replace(Recordset1__r_name, "'", "''") + "%'
Is there something incorrect in the concatenation part of the code ? I
am using MS Access.
I have two fields First_Name and Last_Name. I want to search for John
Smith by entering "John", "Smith" or "John Smith". I have tried to
concatenate the fields with this code and it works with "John" and
"Smith" but comes up blank when I enter "John Smith".
SELECT First_Name, Last_Name FROM ASPP_Users WHERE (First_Name + ' ' +
Last_Name) Like'%" + Replace(Recordset1__r_name, "'", "''") + "%'
Is there something incorrect in the concatenation part of the code ? I
am using MS Access.