Is there a way to declare a logical operator (ie: <=, >, etc...) in a module to be referred to in various queries? I have multiple queries that require the same criteria but only want to have to update the criteria in one location if possible. I have been using the following language but get a data type mismatch when I use the function in my select query criteria. I query works when I drop the "<=" in the below language. I have also tried the second set of language (below), yet that does not work either.
[code]
Function TestCriteria()
TestCriteria = "<=4"
End Function
[code]
-----
[code]
Function TestCriteria()
TestCriteria = "<=" & 4
End Function]
[code]