Hello,

Quick and easy question, I hope.....

Without using a text fieldtype, how can I get Access to store and
display the number 12.1.2 or 1.3.9 ?

"Chris" <chris.hogan (AT) gmail (DOT) com> wrote

The only way (AFAIK) without using text field type is to store each number
in it's own field, then concatenate them for display:

Field1 = 12
Field2 = 1
Field3 = 2

Then, to display:

Field1 & "." & Field2 & "." & Field3

Chris <chris.hogan (AT) gmail (DOT) com> wrote in news:92a4112f-2e3c-4570-932f-
3a0a6f26a777 (AT) 28g2000hsw (DOT) googlegroups.com:


These are hiearchical identifiers, and can be stored either as
separate fields or you can store the various levels in a common
numeric field by scaling them. 12 *10000 + 1*100 + 2*1 and then
descaling for display.

What is your objection to storing them as text?

--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com