CA:Acct#878 Name: Nash Zip:60651 Bal:3454.156761338234
CA:Acct#124 Name: Bob Zip:60623 Bal:9330.436335427394
SA:Acct#377 Name: Bob Zip:60623 Bal:5176.021326329733
CA:Acct#330 Name: Steve Zip:60609 Bal:4475.829967882866
SA:Acct#292 Name: Richard Zip:60654 Bal:1787.1918223355153
CA:Acct#493 Name: Nash Zip:60608 Bal:578.3817545856074
CA:Acct#801 Name: Jacob Zip:60610 Bal:8675.36939089393
CA:Acct#130 Name: Crosby Zip:60611 Bal:3519.3535386995
CA:Acct#260 Name: Michael Zip:60618 Bal:554.1668215122276
SA:Acct#171 Name: Jacob Zip:60623 Bal:5003.089610170856
CA:Acct#851 Name: Jacob Zip:60651 Bal:3436.8046938701023
SA:Acct#142 Name: Richard Zip:60610 Bal:2631.9119945488587
SA:Acct#898 Name: Crosby Zip:60654 Bal:1821.7246675470344
SA:Acct#235 Name: Nash Zip:60610 Bal:2734.9665579967473
CA:Acct#569 Name: Jacob Zip:60644 Bal:5432.621182238243
CA:Acct#372 Name: Crosby Zip:60654 Bal:9827.615101169255
CA:Acct#346 Name: Crosby Zip:60654 Bal:5250.633314985043
SA:Acct#414 Name: Richard Zip:60611 Bal:5307.25021688474
SA:Acct#631 Name: Stills Zip:60611 Bal:5603.150073810688
SA:Acct#558 Name: Larry Zip:60611 Bal:5876.585306422419
Blah blah debug for sorting by name
CA:Acct#124 Name: Bob Zip:60623 Bal:9330.436335427394
SA:Acct#377 Name: Bob Zip:60623 Bal:5176.021326329733
CA:Acct#130 Name: Crosby Zip:60611 Bal:3519.3535386995
SA:Acct#898 Name: Crosby Zip:60654 Bal:1821.7246675470344
CA:Acct#372 Name: Crosby Zip:60654 Bal:9827.615101169255
CA:Acct#346 Name: Crosby Zip:60654 Bal:5250.633314985043
CA:Acct#801 Name: Jacob Zip:60610 Bal:8675.36939089393
SA:Acct#171 Name: Jacob Zip:60623 Bal:5003.089610170856
CA:Acct#851 Name: Jacob Zip:60651 Bal:3436.8046938701023
CA:Acct#569 Name: Jacob Zip:60644 Bal:5432.621182238243
SA:Acct#558 Name: Larry Zip:60611 Bal:5876.585306422419
CA:Acct#260 Name: Michael Zip:60618 Bal:554.1668215122276
CA:Acct#878 Name: Nash Zip:60651 Bal:3454.156761338234
CA:Acct#493 Name: Nash Zip:60608 Bal:578.3817545856074
SA:Acct#235 Name: Nash Zip:60610 Bal:2734.9665579967473
SA:Acct#292 Name: Richard Zip:60654 Bal:1787.1918223355153
SA:Acct#142 Name: Richard Zip:60610 Bal:2631.9119945488587
SA:Acct#414 Name: Richard Zip:60611 Bal:5307.25021688474
CA:Acct#330 Name: Steve Zip:60609 Bal:4475.829967882866
SA:Acct#631 Name: Stills Zip:60611 Bal:5603.150073810688
Campbell Ritchie wrote:By the way, I think there is a risk of collisions (two people with the same account number) if you use that method of allocating account numbers.