So the $ sign is always present? Is there only one dollar amount in each paragraph? Is each paragraph in a table field?
If yes to all, try a function that will check the string for the variations and return correct result. Something like:
Code:
Public Function DollarAmt(s As String) As Double
If InStr(s, "$") Then
s = Mid(s, InStr(s, "$") + 1)
If Mid(s, Len(Trim(Val(s))) + 1, 1) = "k" Then
s = Val(s) & "000"
Else
s = Val(Replace(s, ",", ""))
End If
Else
s = 0
End If
DollarAmt = s
End Function
Then call the function in a query or textbox like: DollarAmt([fieldname])