Query Question

[dmaier]

I have a table that has team schedules and consists of the followin
fields:

HomeTeam, Opponent, Location, Date, Time

What I would like to do is to write a query that could query on
specific team, let's say Barracudas but some time the Barracudas ar
the HomeTeam and sometimes they are the away team(Opponent)

Is there a way to structure a query to be able to do that

 

[damien]

this is actually very simple.
open a new query in design view
add your team schedule table to it.
add all of the fields that you want to see in the query.
in the CRITERIA space for the hometeam field type
barracudas
then in the OR space(below CRITERIA) for the Opponent
field type barracuda again.

ie. assuming your table name is schedule,

Field: Hometeam ! Opponent ! Location !etc
Table: Schedule ! Schedule ! Schedule !
Total:
sort:
Show:
Criteria: Barracudas!
Or: !Barracudas !


then run the query an all of the games with the barracudas
will be displayed