If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Suppress Leading Zero
I have a report that is sorted by Floor, Department, then by Room. My floors
are 1-12. In order to get them to sort properly I have them in the database as: 01, 02, 03, etc else they sort like this 1, 10, 11, 12, 2, 3, etc. These are showing on my report as: 01, 02, 03, etc and I only want them to appear as a single digit, 1, 2, 3, etc. I tried setting the format to ## but it still shows the leading zero. Any suggestions. Dawn |
Thread Tools | |
Display Modes | |
|
|