Number Conversion

  • Thread starter Thread starter Tom Bock
  • Start date Start date
T

Tom Bock

I have an outline that contains multiple levels.

1
1.1
1.1.1
1.1.1.1
2



As shown in the example, the "1", "1.1", "2" entries are interpreted as
numbers (as expected). The other 2 values ("1.1.1" and "1.1.1.1") are
interpreted as text (due to the multiple dots).

Can I somehow "trick" Access (via creating some conversion function) so that
any number like "1.1.1" or "1.1.1.1" can also be read as a number?


Thanks,
Tom
 
Tom

Why? As in "why do you want these all to be treated as numbers" -- what are
your intentions...<g>?

By the way, "numbers" that have a decimal point (".") only have one -- so
how do you want Access to interpret a "number" of the form "1.1.1.1"?
 
Jeff:

Yep, I see your point... by definition, numbers only have 1 decimal. Maybe
I should convert them all to text.

At this time, I simply investigating as to how I can deal with an outline
(in Word) that needs to be converted in Access.

I am hoping to develop some kind of system that will automatically
increase/decrease the level -- create 1.1.2 if the previous row/record
contains 1.1.1.

Again, I'm not sure right now where I'm going w/ this. Simply exploring
options.


Thanks,
Tom
 
Tom

If you have levels, sub-levels, and sub-sub-..., consider using one field
per.

That way, you can keep the levels separated, but show a given
object/line/whatever as belonging to whatever combination.

Good luck

Jeff Boyce
<Access MVP>
 
Back
Top