Query problem with function left and len

[krzysiekk]

Hi I try use function left and len,

Function:

Field1: trim(left([Field0],len(Field0)-1))

not working any sugestions?

 

[vbaInet]

What are you trying to do? And how is it not working?

 

[krzysiekk]

I got information like:
500g
10g
1000g
1g

I want remove g

 

[vbaInet]

Use this:
IIF(Len([Field0] & "") <> 0, Val([Field0]), [Field0])

 

[krzysiekk]

thanks

working fine

 

[vbaInet]

No problemo!