beginner query question

[JimO]

I have a sports database with only one table. It contains fields titled, 'Home team' and Road team'. A given team name may appear in either the 'Home team' or the 'Road team' field.

I want to have access select all RECORDs that contains the a specified team name regardless if it appears in the 'Home team' or the 'Road team' fields.

This seems simple but i have not figured out a way to do it. Can someone advise?

 

[Maquis]

SELECT * FROM table1
WHERE [Home team] = "teamname" OR [Road Team] = "teamname"


Just cut and paste the above into the sql view window of your query design and it should work. Substitute your table name for "table1"