Access 2003 Query

[Michelle Whitfield]

Hi, I hope you can help me. I am trying to write a query where I can search two fields and bring back the results ( by last name). The fields names are Owner Name and Joint Owner Name. Can you please help?
Thanks,
Michelle

EggHeadCafe - Software Developer Portal of Choice
Toward Viable CAPTCHA Alternatives
http://www.eggheadcafe.com/tutorial...c-a34cd08623e8/toward-viable-captcha-alt.aspx

 

[KARL DEWEY]

The way you posed your question there are different solution based on how you
really mean it.
SELECT [Owner Name], [Joint Owner Name]
FROM YourTable
WHERE [Owner Name] = [Enter last name] AND [Joint Owner Name] = [Enter last
name];

SELECT [Owner Name], [Joint Owner Name]
FROM YourTable
WHERE [Owner Name] = [Enter last name] OR [Joint Owner Name] = [Enter last
name];

SELECT [Owner Name], [Joint Owner Name]
FROM YourTable
WHERE [Owner Name] = [Enter last name];

SELECT [Owner Name], [Joint Owner Name]
FROM YourTable
WHERE [Joint Owner Name] = [Enter last name];