Hi
Well i have a problem while updating a query.
I have a table which has the following fields
studid,lastname,sex,country,permanentaddress,perma nent number.
Now i create a query from this table say,Query1 in which i have the fields
studid,lastname,sex country with a criteria as country should be equal to USA.
Next i create a query say query2 with fields permanent address,permanent number where studid id equal the ones in query1.
While i try to update the data of query2 i get a message
This recordset is not updateable.
Can you tell me a resaon for this.

Search help for "TroubleShoot Select Queries", select "I can't update data..." for more information about when queries are updatable and when they are not.