J
jsawyer78
I have query using two linked tables. Table one has an agent code (unique)
and the agents first name. Table two has the agent code (not unique) and a
freeform text field. I join the tables based on the agent code and want to
search all records where the free form text field contains the agents first
name. It wants to search on the field name rather than the contents of the
field. The sql is:
SELECT MLSADMIN_PROP_1.MLS_ACCT, MLSADMIN_PROP_1.REMARKS,
MLSADMIN_MEMBERS.LA_FIRST_NAME
FROM MLSADMIN_MEMBERS INNER JOIN MLSADMIN_PROP_1 ON
MLSADMIN_MEMBERS.LA_LA_CODE = MLSADMIN_PROP_1.LA_CODE
WHERE (((MLSADMIN_PROP_1.REMARKS) Like "*[mlsadmin_members]![la_first
name]*"))
ORDER BY MLSADMIN_PROP_1.MLS_ACCT;
and the agents first name. Table two has the agent code (not unique) and a
freeform text field. I join the tables based on the agent code and want to
search all records where the free form text field contains the agents first
name. It wants to search on the field name rather than the contents of the
field. The sql is:
SELECT MLSADMIN_PROP_1.MLS_ACCT, MLSADMIN_PROP_1.REMARKS,
MLSADMIN_MEMBERS.LA_FIRST_NAME
FROM MLSADMIN_MEMBERS INNER JOIN MLSADMIN_PROP_1 ON
MLSADMIN_MEMBERS.LA_LA_CODE = MLSADMIN_PROP_1.LA_CODE
WHERE (((MLSADMIN_PROP_1.REMARKS) Like "*[mlsadmin_members]![la_first
name]*"))
ORDER BY MLSADMIN_PROP_1.MLS_ACCT;