Joining Tables in a Query

[Jammin]

I am a beginner to Microsoft Access 97 and a beginner to programming. I am trying to do a simple query with three tables. A common column is set in each table called TagName. The first table contains tagnames for all the data. (Tagnames from the other two tables can all be found in the first table.) I want to join these tables so that it will list all the information from all three tables, listed in ascending order of TagName. I have little background in programming and have come to the conclusion that I will need some code.
Any help would be greatly appreciated.

Thanks

 

[Jammin]

Thanks, I had no idea how to access the join properties. Your time is greatly appreciated.
Jammin

 

[bhp59]

Pat,
Could you give an explanation of what you mean by result set.

Thanks,
bhp59

 

[bhp59]

Thanks, I'm definitely having trouble figuring out how to da this report.

bhp59