>How can I pad an expression (character or numeric) with a character?
>
>For example:
>
>I want to store 1 as 0001
>
>In VFP the syntax is padl(expression,4,'0') but obviously this didn't work in Access. Any help would be appreciated

For A97 and earlier: http://support.microsoft.com/support/kb/articles/Q96/4/58.ASP