Need help! I'm tryin to add leading zeros to a field by creating a new calculated field (Numeric) and need a formula to add leading zeros (field length 7):
this what i have:
Ah, the old Str() function trick. It's this one:
Str(RptNum;7;0;"0")[/CODE]But this field must be a Character field in order to display the leading zeros.
perfect! works every time
Retrieving data ...