>I wrote a user defined function called CleanString:
>
>

>Public Function CleanString(String2Clean As String)
>
>    RetVal As String
>    
>    String2Clean = Replace(String2Clean, "'")
>    String2Clean = Replace(String2Clean, "(")
>    String2Clean = Replace(String2Clean, ")")
>    String2Clean = Replace(String2Clean, "$")
>    
>    CleanString = RetVal
>
>End Function
>

>
>I want to call it in a query I'm working on. So in the expression builder I tried:
>
>

>VN-PAID: CleanString([VEN_YTDPaidAmt])
>

>
>I get "Undefined function 'CleanString' in expression".
>
>How do I do this?

In SQL Server it would be dbo.CleanString([myField])