Search results

In database I have a field date. I want that when I enterd a date in the form,it should automatically copied to the next record till I make changes in that field. Pl. tell how to do this. The data should be stored in the table.

In access in one field I have one date and in another field I have another date. I want to calculate the number of years.,months and days elapsed between these two date. e.g. suppose in one field I have 30.06.2005 and in other 20.04.2004 then it should show 1 year 2 months and 10 days.

Thanx Dear Mstef Thanx for u'r suggestion with regards. 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...

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...