Query and update data

[baijuep]

i have two access databases one name wing.mdb and another is pooja.mdb

common field in both is PNO

already there is data in baiju (table name in pooja.mdb(database) and blank field named qual and rec

There is a table named Mqual(table) in wing.mdb(database) with PNO, qual, grading, institution, from, to, Rec,remarks (fields in Mqual table).

i want to copy those who have done OTY to qual ,rec field in baiju(table) in pooj.mdb(where there is already other data and one common PNO for each persons

and

i want those who had done OY+MED or LED to qual ,rec field in baiju (table) in pooj.mdb(where there is already other data and one common PNO for each persons.

The table in wing.mdb named mqual has multiple rows for one person as one should have done more than one courses and i want only the criteria mentioned above to be copied

 

[CJ_London]

Not quite sure what you are tring to do but if you link the tables (using external data tab/access) in one database to the other you should be able to write the appropriate queries

 

[baijuep]

i know about linking but when u look to my two tables and the structure and my requirement. Then the linking is not the solution.

I am willing to count COY(field) from PERS table and update the count number in HELD (field) in front of that COY in authpers table.