copy field ? resolved

[indiewolf]

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



kindly help
cheers

[DKenny]

I assume you are talking about access?

Use the following SQL statement

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

[indiewolf]

I assume you are talking about access?

Use the following SQL statement

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

[Siddharth Rout]

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?