on 2010 Mar 29 6:48 PM
For some reason I can't remember how to force a number to show leading zeros in a fixed length field, i.e. 80 is 0080, 240 as 0240. I'd blame it on Monday but I couldn't think of it on Friday, either.
Thanks!
Robin
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
cstr(,"00000000")
Thanks for your response. I had to change the cstr to totext in order for it to work, but then it was perfect!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.