Numbering Problem

[Guest]

I have an excel worksheet that I export to Access for reporting purposes. The
subjects in the worksheet rows are numbered thus:
1.1.1,1.1.2,1.1.3........1.1.10,1.1.11 etc. and when a new subject is entered
on the same worksheert it is numbered as 2.1.1,2.1.2....2.1.10 etc.

The problem is when I export this to Access the report interprets some of
the numbering sequence as say 5.1.1 then 5.1.10 then 5.1.2. In other words
picking up that 1 then 0 comes before 2. Am I explaining this?

Very annoying...any suggestions?

 

[Dave Peterson]

I think you'd be better served by using numbering like:

1.01.01
or
1.0001.0001
(Use as many 0's as you need.)

 

[Pete_UK]

These are treated as text, but you want part of them to be considered
as numbers. To get the correct sort order, you will have to insert
leading zeros in the final part, i.e.:

1.1.01, 1.1.02, 1.1.03........1.1.10, 1.1.11 ... and 2.1.01,
2.1.02 .... 2.1.10 etc

If your first or middle digit can exceed 9, you will also need to make
these have leading zeros.

Hope this helps.

Pete