Number Calculation?

[FruitFul]

I have a field that represents a Pose Number.

When I print I have it set to sort the records by this number. However, I get things like:

102

11

121

27

4

616

63

So I was thinking I would make an additional calculation field that took the number and added zeros in front and sort by this.

I assume this is possible? How do I go about writing such a calculation?

[Raybaudi]

Hi

the only thing that you have to do is to change PoseNumber to number ( not text) !

[FruitFul]

lol - I feel like an idiot : Thanks!

[Lee Smith]

Don't, because we all do the same thing.

When is a number not a number?

There are lots of time when the opposite is true too.

Sometimes a number is better off being text, and sometime, we call things numbers that are not really number, only contain some (maybe). (i.e. Client ID Number, Social Security Number, Phone Number, etc.).

Lee

[Lee Smith]

I also should mention that you can leave it as text and use either a Calculation Field or Auto Enter with the Right Function.

Right ( "000" & YourField ; 3 )

Would make your sample:

102

011

121

027

004

616

063

which can be adjusted to any number of digits you want, and then you can sort as you want.

Lee

Edited November 30, 2005 by Guest
oops