copy field ? resolved

kindly tell me whether this can be done by validation rule or by macro, if yes how.



kindly help
cheers

I assume you are talking about access?

Use the following SQL statement

Code:

---

UPDATE TABLE TableName SET b = right(a,16)

---

Quote:

---

Originally Posted by DKenny

I assume you are talking about access?

Use the following SQL statement

Code:

---

UPDATE TABLE TableName SET b = right(a,16)

---

---

yes you are right i am talking about access.

i did put your code in my sql query,in the update to field in query design. but the problem is it copies 0 to all the records in column(field) b.

why is that happening?
kindly cheers

Quote:

---

right(a,16)

---

I might be wrong but i thing you also need to check if

trim(right(a,16))<>""

to make sure blank values are not copied?