If the numbers are key pointers (like employee numbers or department numbers or asset numbers), rather than counts or values, it's sometimes helpful to place them in fields with leading zeros.

"0001" for "1"

It eliminates the worry about actual leading blanks. It also helps with visually verifying concancenated multi-field keys.

SET 2 CENTS OFF

>How do I sort a table on a numerical field so that I get the following:
>
>1
>10
>100
>101
>102
>1001
>1002
>etc...
>
>as opposed to this:
>1
>10
>100
>1001
>1002
>101
>102
>etc....
>
>Thanks in advance for your help,
>Russell