Query Help

[etjohnson81]

I have a table as follows

MatchID | dateMatch | numHomeTeam | numVisTeam | etc...
1 10/5/2006 1 2

and another table which contains the team information. I want to do a query that will use the example data above but show the team names as well, kind of like a report or schedule. I say I want to use a query because I am incorporating this into an ASP application. Anyone have any ideas? Also it is an MS Access database.

<A href="

http://www.easycgi.com/shared_hosting/?kbid=4815&img=easycgi_120x60_5.gif">

<img src="

http://banners.easycgi.com/ShowBanner.asp?id=4815&img=easycgi_120x60_5.gif"

border=0></a>

 

[Fenrirshowl]

If you have a table with the team numbers and names in:
1) start a new query in design view
2) add both tables
3) drag the numHomeTeam field to numTeam (assumed name there) in your other table to create a link
4) do the same for the visitors
5) select the required fields to show in the output of your query (from either of the tables)
6) run the query

Fen