Recent content by cptnspoon

Oh wait, now that I tried to imlement it I am getting a "The expression you entered is too complex" error in the Query when I try to build the function call (I assume because of the amount of arguments). Now I'm back to square one, however I have rewritten the function to work (from the VB...

EDIT: I spoke too soon! Please see below!!!! Thanks for that lagbolt, works like a charm. Much appreciated!!:D

First up, is it possible to pass a set of values into a function as an array ie: qryTest has var1 var2 var3 var4 Can I pass it into a function that looks like this: Public Function FunctionTest(varArray()) ...etc End Function And just do this in my Query: Field1...