User Support Forum

I want to do a custom report with each individual's name and their membership # in numerical order. I have it set for output to be member's last name, first name, and membership # and I clicked on "SORT" for membership #. When I do this, the numbers are like 9,97,96, etc and #8 comes after 90. Can anyone help me so it will be in correct numerical order?

This is a character field and not a true numeric field. It is done this way to allow you to enter and text into the field and not just numbers.

If you want it to sort correctly, you will have to format the numbers in the field the same way with the same width. For example you would need to enter the like this.

0001
0002
0003
0004
0005
0006
0007
0008
0009
0010
0011
0012
0013

...

0099
0100
0101

If you already have updated all the profiles with the member numbers, tech support may be able to help you get them in the right format to sort correctly.

Thank you so much! Makes sense now and I can fix it.