I must zero fill a text field in a query but not sure how to go about it.
Suggestions anyone?
Thanks!
Try String() function. See Basic Language Reference in your Access Help.
Good Luck!
--
Chaim
> I must zero fill a text field in a query but not sure how to go about it.
> Suggestions anyone?
>
> Thanks!
> --
> NC Beach Bum
NC Beach Bum - 31 Aug 2005 22:10 GMT
Cham,
Thanks for the tip!
Your answer led me to the following solution to resolve right justification
of data with leading zero's to pad the data in a fixed length field.
Checks dollar value = ChecksAmount
The character field is a fixed 10 characters in length.
The line of code used:
ChkAmt: String(10-Len(LTrim([ChecksAmount])),"0") & [ChecksAmount]
The output ended up as
0000008192
0030128300
etc.
Thanks! again.

Signature
NC Beach Bum
> Try String() function. See Basic Language Reference in your Access Help.
>
[quoted text clipped - 9 lines]
> > --
> > NC Beach Bum