Access 97, linking tables

[bdjb]

Windows XP
Access '97
I have 3 tables that contain data with similar data (Split by type of server). I want to link each table on data that is the same (site name) so that I can get a list of servers at each site. If I do a query and link by site, I get the biggest amount of data, with data from of the smaller table repeating.
What I get is:
site a
server type 1 server type d server type x
server type 2 server type d server type y
server type 3 server type d server type y
etc.

What I want is:
site a
server type 1
server type 2
server type 3
server type d
server type x
server type y
etc.
Hopefully that makes sense!

Thanks in advance

What happens if you get scared half to death twice?

Bob

 

[bdjb]

The powers that be just approved re-doing the tables to put all similar data in one table, so that fixes my problem. Thanks to anyone who looked at this post.

Bob

What happens if you get scared half to death twice?

Bob