val() function in query - without causing circular reference. (1 Viewer)

[Leo_Polla_Psemata]

Hi, I have a field, name "weight", data type short text.
The data is displayed like this 00015300.350
I can convert this to number by using the val function in query like this. expr1:val(weight)

The question is IF we can keep the name of field "weight" in the query, without causing circular reference.
Is there any workaround ?

 

[isladogs]

You will need to use a different name e.g. WeightX
However if its a big issue, save the query then create a new query based on that and add a field: Weight:WeightX

 

[Leo_Polla_Psemata]

Thanks, this is what I am doing, no big issue but, as time grows on, i end up with too many objects in my database,
many of those redundant and is a bit difficult to tide it up.

 

[Pat Hartman]

Why not fix the data type to be numeric? If you also need UOM, store it in a separate field.

 

[isladogs]

I had to look this up:

UOM may refer to: Units of measurement ·

 

[Pat Hartman]

Sorry, that's a fairly common acronym in manufacturing or inventory systems in the US. It isn't industry specific.

 

[isladogs]

No worries. Tony Hine keeps saying I use acronyms all the time. It may be common in the UK as well for all I know but it was new to me.