A table needs to have an Account Number field. The account could possibly be up to 16 digits and as few as 2 digits. I would like to sort by the field. This field will be part of an imported table. Also, I would like to format the field with dashes / spaces similar to a credit card number: 1234-5678-8765-4321. Is Data Type Number and Field Size Double the best?
