update query

[amna77]

hi I have 2 fields in my update query, one is txtPartNum and other one is txtBaanNum. txtBaanNumber I want to update, it should equal to txtpartNum. so what ever value is in txtpartnum, should update table, so that txtbaannum will have same value as well. when i view the query then it gives me right data, but when i click on run, then it does not update the table. why?

 

[SydneyGeek]

I'm assuming that you put [txtPartNum] in the Update To line for txtBaanNum. If you did, the query should update as expected. If you did that and it still doesn't update, then I don't know

Denis

 

[Andrew Fergus]

If you can't get it to work after following the suggestion from Denis, can you post a copy of the SQL for the query? You can get to the SQL in your query design by clicking View -> SQL View, you can then copy and paste it into your response.

Andrew