I have a field which looks like this - "d123456", I will have to display the field without the "d" in front, meaning I will need to show "123456" Any idea how I can do this? Thanks!

If the field is always the same length then use

Right([nameofyourfield],6)

Thanks for your reply.
But the number of characters in the field varies. Sometimes it is d123 sometimes it can be d12345, etc.

Try this:

Right ([FieldName],(Len([FieldName] - 1)))

This one worked

Right([Orig],Len([Orig])-1)

Thanks!!