master table

[ronnie h]

what is the best way to make master table with just one each of all the fields in impact and masc

[Rick]

The way I did it was to create a query to create the pgm# field in ALL_MSAold.

I renamed ALL_MSA to ALL_MSAold so I could call my master table ALL_MSA and my old queries would still work.

I then have a 2nd query that I made as a make table query the first time I used it. After the table is created I canged it to a apend query.

Now I have to look at adding ALL_HX1 fields to the master table.

[MikeDee]

Reddy

read the following article
http://www.homebased2.com/km/pdf/Relationships%20in%20Access.pdf

gives you the lowdown on how to join tables.

You need to join 4 fields date, track, race no. and ppo you can do this with msac, impact and hx1. once you have them linked, do as Ricks suggests. Make a new table with the fields from any of the 3 linked tables into a new table. Once done save the query as a append query and you can use it to add new data to your combined table.