Criteria data type mismatch

  • Thread starter Thread starter ET
  • Start date Start date
E

ET

I have the following datafield

LastLengthBack: Mid([R1],20,3)

which returns a sample data of
10
5
3.3
1.8

and am trying to set a criteria of <=4.5 and am receiving
a data type mismatch

Any ideas of how I can correct this?
Thanks in advance
 
Hi,

The Mid function returns a string, which you can't compare to a numeric
value (single), try using

LastLengthBack: Val(Mid([R1],20,3))

I haven't tried this so it may crash and burn, but converting the result of
the Mid to a numeric value is what you need.

MFK.
 
Back
Top