Hi.
Here is an example of a function that is of a custom type:
Now, in a query I want to be able to use fun1(1,1).answer1 in criteria but receiving the following error:
The expression you have entered has an invalid . (dor) or ! operator or invalid parenthesis.
Is there any workaround here?
Here is an example of a function that is of a custom type:
Code:
Public Type typ1
answer1 as integer
answer2 as integer
End Type
Public Function fun1 (var1 as variant, var2 as variant) as typ1
fun1.answer1 = var1 + 1
fun1.answer2 = var2 + 2
End Function
Now, in a query I want to be able to use fun1(1,1).answer1 in criteria but receiving the following error:
The expression you have entered has an invalid . (dor) or ! operator or invalid parenthesis.
Is there any workaround here?
Last edited: