I have a table with data as below
I need a query which would derive the fields from this data such as,
MessageType : IIF(Left([F1],4=":20C"),Right([F1],10)). I need o get the value as ICF0000325 (the second row)
But it is giving #Error
TIA
I need a query which would derive the fields from this data such as,
MessageType : IIF(Left([F1],4=":20C"),Right([F1],10)). I need o get the value as ICF0000325 (the second row)
But it is giving #Error
TIA