Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2005

    Arrow 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

  2. #2
    Join Date
    Nov 2005

    Dao Sql

    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:
    IIF([Field1]>1, "Ok")

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts