Numbers in a table

[cathyspark]

I have set up a basic database for stock control in a small business. I had sifferent tables for different areas of stock and had numbered them A101 A102 A103. This worked fine till I came to A999 and when I went to A1000 the number stoped appearing in order. Now my number go A1009 A101 A1011.

Does anybody know how I can get them back in order.

[Robeen]

Are you saying your TABLE NAMES are A101 A102 A103 . . . A1009 A1011 . . . etc?

Is Changing your Table Names an option?

I've run into this problem when I was naming files that I regularly output like this:
FileName_01-10-2009.txt
FileName_01-15-2006.txt
FileName_05-10-2007.txt

these get sorted by the first digit - then the first two digits . . .
So - the files above - when sorted - appear in the order shown above . . . when you'd actually like to have them appear in chronological order like this:
FileName_01-15-2006.txt
FileName_05-10-2007.txt
FileName_01-10-2009.txt

If you want to keep your naming convention that you set the original Tables up with, you could add a digit to your three-digit table names.

These:
A101 A102 A103

Would become:
A0101 A0102 A0103

Then your Tables will line up the way you want.

I don't know how heavily 'invested' you are in those names, however.
I have got myself into serious trouble changing table names late in the process.

If you have tons of queries, reports etc that already use the existing tables - changing their names could become nightmarish and I would not advise it.

Alternatively - if you can program your brain to think of the ordering the way Access does - the way your tables are arranged will become 'logical' to you.



All the best!