ajaymansata
Registered User.
- Local time
- Today, 08:04
- Joined
- Dec 17, 2001
- Messages
- 25
Hi
Well i have a problem while updating a query.
I have a table which has the following fields
studid,lastname,sex,country,permanentaddress,permanent 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.
Well i have a problem while updating a query.
I have a table which has the following fields
studid,lastname,sex,country,permanentaddress,permanent 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.