Search results

Hello Everyone!, I have two issues: 1. I have a month field with month values and a year field with year values .... I would like to combine them into a date field ex: 8 2012 8/2012 2.The second is a little more complex: There are two fields- the first field is a mixture of positive...

That did the trick! Thank-you everyone.

I have updated the module with Public Function ParseText(TextIn As String) As String However in the query entry: ParseText([Expression],1) It replys: "The expression you entered has a function containing the wrong number of arguments."

Out of the three selections - module, class module, procedure. I selected module. It is correct that the function name in the code is the same that I used in the query call.

I have entered the function below in the vba module: Public Function ParseText() On Error Resume Next Dim var As Variant var = Split(TextIn, " ", -1) ParseText = var(X) End Function but when I try to execute: ParseText([Expression],1) It replies "Undefined fuction "ParseText' in expression"...