Results 1 to 10 of 10

Thread: DAO, SQL Case Statement

Hybrid View

  1. Oct 5th, 2005, 11:18 AM #1
    dannymking
    dannymking is offline
    Fanatic Member dannymking's Avatar
    Join Date
    Jul 2005
    Location
    Darlington, North East UK
    Posts
    677

    Re: DAO, SQL Case Statement

    If this is Access I don't think the CASE statement is available against the JET engine.. you might want to take a look at the IIF Statment instead..

    Select (IIF([Index1] ='XXX','11',[Index1])) As Expr FROM [01_INFO]")
    Danny

    Never Think Impossible

    If you find my answer helpful then please add to my reputation
    Reply With Quote Reply With Quote
  2. Oct 5th, 2005, 11:21 AM #2
    ghislain007
    ghislain007 is offline

    Thread Starter
    New Member
    Join Date
    Oct 2005
    Posts
    5

    Re: DAO, SQL Case Statement

    Problem Sloved!!!!!!!

    Danny is right Acces doesn't support the case statement.



    Thanks again!!!
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width