how do i add the variables from one table to other

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hallo

I have more than two tables; I want to merge some variables from each table
to the main table. All the tables have variables (field names) Station,
Month and Year are common variables. Other tables have some variable,
including common variables like (number of rainy days > 25mm) etc.

When joined these tables using queries out put file will show only related
records.

Can some body help me to solve this problem? The particular variable should
join in the main table. I want all the records should present in the out put
table including the new variable fitted in the corresponding record.

Thanking you

Vijay
 
You don't need to add variables: you need to create a query that joins the
various tables together.

Use that query wherever you would otherwise have used the table(s).
 
Back
Top