How can copy data from one field to another field in the same table? Let's say I have a test table and two fields in it.
field ID 50000 "no-old" which has data
field ID 50001 "no" has no data.
I want to copy data in "no-old" to "no" field.
I am writing a report to copy a field from one to another and I thought one single line would do the trick but it doesn't copy anything.
no := "no-old";