Can anyone show me the correct code to perform a Case When statement using DAO 3.6 object library?
I've tried a couple of things but with no results:
ex: Select case [field1] when > 1 then 'OK' end

Thanks for your help