C
Crystal via AccessMonster.com
Can I string two columns (lastname, firstname) together and use the string in
a query to query a fullname column? I have a table with two columns: [last
name] and [first name]. I need to string them together with words “LIKE” and
“OR” (LIKE [lastname]*[firstname]* OR LIKE… ) so that I don’t have to type
the names one by one to query a full name column. The query would be like :
LIKE SMITH*JOHN* OR LIKE WHITE*MATT* OR LIKE …
Can I do this?
Thank you in advance.
a query to query a fullname column? I have a table with two columns: [last
name] and [first name]. I need to string them together with words “LIKE” and
“OR” (LIKE [lastname]*[firstname]* OR LIKE… ) so that I don’t have to type
the names one by one to query a full name column. The query would be like :
LIKE SMITH*JOHN* OR LIKE WHITE*MATT* OR LIKE …
Can I do this?
Thank you in advance.