dave
03-16-2006, 03:14 PM
This is for my own reference:
LINE2: IIf([TAG_REG]![TAG_NO] Is Null,"#B#",Mid(([TAG_REG]![TAG_NO]),InStr(([TAG_REG]![TAG_NO]),"-")+1,6))
In Access, the Mid function extracts a substring from a string (starting at any position).
The syntax for the Mid function is:
Mid ( text, start_position, number_of_characters )
LINE2: IIf([TAG_REG]![TAG_NO] Is Null,"#B#",Mid(([TAG_REG]![TAG_NO]),InStr(([TAG_REG]![TAG_NO]),"-")+1,6))
In Access, the Mid function extracts a substring from a string (starting at any position).
The syntax for the Mid function is:
Mid ( text, start_position, number_of_characters )