kindly tell me whether this can be done by validation rule or by macro, if yes how.
kindly help
cheers
Printable View
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
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
I might be wrong but i thing you also need to check ifQuote:
right(a,16)
trim(right(a,16))<>""
to make sure blank values are not copied?