I have a report that I have to run that is supposed to show a list of 4 digit codes. However if the code happens to start with zeros it will not display them. Example if the code is "0062" it will only show as "62" but I need it to show all 4. I've tried to use input masks but other than that I really wouldn't know how to show preceding zeros. Any suggestions?
Adding zreos (1 Viewer)
- Thread starter Hecronis
- Start date
- Local time
- Today, 10:36
- Joined
- Sep 12, 2006
- Messages
- 15,638
if the leading zeroes are significant, I would store them as text, not as a number format.
Otherwise there is no way to have both "062" and "0062" (if the underlying data is just Integer 62)
Using text gives you the added benefit of being able to use Alpha characters if needed, and may be helpful with sorting.
Otherwise there is no way to have both "062" and "0062" (if the underlying data is just Integer 62)
Using text gives you the added benefit of being able to use Alpha characters if needed, and may be helpful with sorting.
Similar threads
