updating field in table

[ananga]

I have some data in a field with text type. I want to update some data in the field basing on a criteria by adding text to existing field by using update queries.For example suppose I have "rs" in the field . I want to add "D" to the field then it becomes "rsD". pl. tell me how to do this? or which functions should be used in the queries.

 

[MStef]

Try this in query;

Update To "rsD"
Criteria "rs"

 

[ananga]

updating table

Pl. go thru my request once again. I want to update several fields basing on a criteria of another field. For example I have 2 fields in a table . Village and population . In the village field suppose a,b ,c,d... and in population field 12,20,0,0,2...... I want to append "i" to each village field whic has population 0. that is in this examble c, d becomes ci , di, like this.

 

[MStef]

Hello ananga!
Look at "DemoUpdateA2000.mdb".
Look at Table1, start Query1, look at Table1.

 

[ananga]

Thanx

Dear Mstef

Thanx for u'r suggestion

with regards.
ananga