Add units to a number field

[thibs27]

Hi,
I just wanted to know if i could add units to a number field, for example write 10 m in a number field
If so, how?

Thanks

 

[boblarson]

First of all, we need a little more information as to what it is you are really trying to accomplish. For example, I can tell you that the answer is YES to your question. However, depending on what you are doing and how you are doing it may determine which way we specify how you should do it, or it could reveal that you are not doing things in a properly normalized way and we should fix that.

So, more information, please - what is it you are really trying to accomplish.

 

[G81]

Hi,
I just wanted to know if i could add units to a number field, for example write 10 m in a number field
If so, how?

Thanks

As far as I know not directly in the number field itself, but you can concatenate the number and the "m" in a query. For example in the query, instead of the number field have:

numberfield2:[numberfield] & " m"

 

[boblarson]

Oh, heavens - did I misread that one. Good catch G81.

No, you can't put that into a number field. You should have another field for UOM (units of measurement).

 

[G81]

No probs Bob. I didn't even realise you had posted. It took me 5 mins just to work out how to spell concatenate . I was spelling it so wrong that not even google helped me.

 

[LPurvis]

You couldn't write the non-numeric value in.
But if the units are predefined (which would make sense - otherwise you need another field to hold those units) then you can format it into displaying as required.
(Seems to be the day for this kind of thing ;-).

Cheers.

 

[thibs27]

The units are predefined, i mean i am using meters for all my database
How can i format it
Thanks

 

[LPurvis]

Format property of simply:
@" m"

 

[boblarson]

Format property of simply:
@" m"

Remembering, of course, that you will need to apply formatting for Reports at the report level when you use them in reports.