var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: DAO, SQL Case Statement
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:
Select case [field1] when > 1 then 'OK' end
Thanks for your help
I was having the same problem and after a few hours of reseach I figured out what's going on...
DAO uses the Jet Engine version of SQL so you need to use MS Access syntax. Try using the following syntax: