Querying data from two fields

I have a table that contains the fields Last_Name and Old_Last_Name, among
others. I'm looking to create a query that will return a record if either
of the fields matches a parameter entered by a user.

How can I accomplish this?

TIA,
Steve

--
Message posted via http://www.accessmonster.com

"Steve Hart via AccessMonster.com" wrote in
message news:4fc2eb3b682341ea80bb46635ded54eb@AccessMonste r.com...
I have a table that contains the fields Last_Name and Old_Last_Name,
among
others. I'm looking to create a query that will return a record if
either
of the fields matches a parameter entered by a user.

How can I accomplish this?

TIA,
Steve


Steve,

It should be something like:

PARAMETERS [Enter Search Parameter] TEXT(255);
SELECT T1.Last_Name
,T1.Old_Last_Name
FROM YourTable as T1
WHERE (T1.Last_Name = [Enter Search Parameter])
OR (T1.Old_Last_Name = [Enter Search Parameter]);


Or, for more flexibility:

PARAMETERS [Enter Search Parameter] TEXT(255);
SELECT T1.Last_Name
,T1.Old_Last_Name
FROM YourTable as T1
WHERE (T1.Last_Name LIKE "*" & [Enter Search Parameter] & "*")
OR (T1.Old_Last_Name LIKE "*" & [Enter Search Parameter] & "*");


(I saved them, so their syntax is ok, but didn't test them.)


Sincerely,

Chris O.