how do i add the variables from one table to other

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
 
D

Douglas J Steele

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).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I remove parent-child relationships in the parent table? 3
How do I Transfer Data from one table to another 6
Separating records all in one table to separate fields 1
Looking information from one table to another.. 4
How do I copy a record from one table to another table in Access 1
Initialize a linking table from existing data? 6
add variable table name to query results 4
how do I add data from one table to another table? 4

Top