arnelgp
..forever waiting... waiting for jellybean!
- Local time
- Tomorrow, 05:27
- Joined
- May 7, 2009
- Messages
- 20,275
you can create a Public function with Split in it and can call it in your query:
public function mySplit(byval sText As Variant; Optional byval sDelim As String :=";"; iIndex As Integer)
'to call:
'mySplit([offerNumber];"-"; 1)
On Error Resume Next
mySplit = Split(sText; sDelim)(iIndex)
end function
on your query:
Highest: mySplit([offerNumber]; "-"; 1)
public function mySplit(byval sText As Variant; Optional byval sDelim As String :=";"; iIndex As Integer)
'to call:
'mySplit([offerNumber];"-"; 1)
On Error Resume Next
mySplit = Split(sText; sDelim)(iIndex)
end function
on your query:
Highest: mySplit([offerNumber]; "-"; 1)
Last edited: