Declaring Logical Operator in Function to be Used in Query

[sdmpp5]

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]

[CJ_London]

nope, only by building the sql in vba.

Alternatively declare in a module (not a form module) - something like

Public Function TestCriteria(Fld as integer; Crit as String) as Boolean

     TestCriteria = eval(fld & Crit)
 
End Function

then in your query, something like

SELECT *
FROM myTable
WHERE testcriteria([fieldname,"<=4")