Monday, July 20, 2009

If statement in the ACCESS:
iif (fieldname is null, 0, fieldname)

Udate any field with the leading Zero(s):
UPDATE table_name
IDENTITY_ID = RIGHT('0000' + IDENTITY_ID, 4)
Posted by at

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.

Subscribe to: Post Comments (Atom)

More Important Links

Followers