Add from two tables into another

[ynnepztem]

I have three tables

Table 1
Language
Pending
Age

Table 2
Language
Pending

Table 3
Language
Pending
Age

I want to write everything from Table 1 into Table 3 and where the Language is the same, add the Pending from Table 2 to Table 3.

Any help once again is greatly appreciated.

 

[mmsbasd]

The quick answer would be to make an UPDATE QUERY, that takes the info from Table 1 and Table 2 and sticks it into Table 3.

You should have a one-to-one relationship between the LANGUAGE field of Table 1 and Table 2. Then, I would make a simple query, using LANGUAGE and AGE from Table 1 and PENDING from Table 2, to verify that the information is lining up right first.

If all is well, you can take that query and convert it to an UPDATE query, pointing the resulting output to the proper fields in Table 3. Run it and it should work.

I'm not that good at explaining the SPECIFICS of setting up the UPDATE fields, because I've only used this process once before, so I apoligize if this provides little help.

Michael Michael
BASD IS/IT Dept

 

[ynnepztem]

Thanks for you quick response. It worked like a dream.