>I want to replace date "18/08/09" instead of "17/08/09 in my "DOA" field of my table(counseling) from record number 1 to 250.
>
>Kindly help for this one.
>
>thanking you
REPLACE Doa WITH Doa+1 FOR Doa = {^2009-08-17} AND RecNo("counseling") < 251 IN counseling
NOT TESTED!! So make sure you have a good backup of that table before you try the code.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.