Long time reader, first time poster. Having some problem with using a UDF as criteria for a query, I can make the UDF spit out a simple string and then use this and works fine, however I need it to create multiple OR criterion and hitting a brick wall, no matter what combination of quotes, double quotes, CHR codes etc I wrap the strings in it's not playing ball. Anyone any ideas?
(I cant put the criteria on multiple rows which would be simple for a long boring reason I wont go into)
This is working......
Public Function BuildCriteria() As String
BuildCriteria = "Example"
...putting an OR statement in there throws an error though