error# in field

  • Thread starter Thread starter GBA
  • Start date Start date
G

GBA

Am manipulating some strings with calculated fields in query.

V87.2

998.4


In both cases I can calc to a new field ok (remove dot, pad 0)

V87.2 V8720

998.4 99840

(these 2 columns are side by side - not sure if this will maintain layout
when posted)

all ok so far; then the third column is a nested Iif dealing with several
columns. The nested iif is selecting which column to use (there are about 8
total). In this example below column 3’s iif would basically state; iif
column2>0, column2 : and all work ok except if the value starts
with V rather number; there are fields that begin with E that work ok…so my
first thought that the >0 was a problem doesn’t seem logical

The fields beginning with V result in ERROR# in the field

V87.2 V8720 ERROR#

998.4 99840 99840

Would welcome advice
 
figured it out

the fields are all genesis as text in table field property...so it never
crossed my mind that they would be viewed as number....plus of course the
fields with a value starting with letter E work fine

but then I realized that in my nested iif I was using iif(Field=0,

which is making the logic numeric

a simple change to iif(Field="0"

and the query keeps it all text - and everything works...
 
Back
Top