Query one search term under multiple fields

[teachEmToBeGeeks]

I am creating a DB for a small organization that works with engaged & newly married women. Thus, the members table stores maiden last names and married last names. Is there a way to enter a parameter (lastName="Smith") and get women whose maiden name was Smith OR whose married name is Smith?
I'm looking for results that might look like this:
First Maiden Married
Katie Smith Jones
Lisa Franklin Smith

Thanks for your time and assistance!

[andy49]

So long as there are separate fields for maiden and married surnames
Use a text box on a form to enter the name then press a command button to run query based on contents of textbox.


Sent from my iPhone using Tapatalk

[rpeare]

let's say your table is:

tblPeople
P_ID  P_Firstname  P_LastName  P_MaidenName 
1     Minnie       Mouse       Rat
2     Daisy        Duck        Mallard

your query would be

SELECT * FROM tblPeople WHERE [P_LastName] = 'Duck' or [P_MaidenName] = 'Duck'

look at the query in a query design window and you'll see what you need to do when you start substituting in field contents from forms.