writing a basic case statement for DoCmd.RunSQL

[masond]

HI All



I need some help writing a DoCmd.RunSQL

Aim > Create a column Called “Channel” by using the following logic below. The data is coming from a file called “test”
If [sub-Source] Is Null Then [how did you hear of us] Else [sub-Source]

Looking forward to your help

[orange]

Have you tried Google or Bing
Ms Access docmd.runsql sample

[masond]

Hi Orange
i been browsing all weekend and i am super confused
I can do a basic, case statement but thats all

[NTC]

As this is an Access forum, and you post yourself as a novice - then I think the best advice is to develop your code using the Query Design View - rather than attempting building with a manual sql statement. You can then change the design view to sql view in order to get the syntax.

[orange]

I agree with NTC -- if you use query designer, then review the sql you will see code that works.

What exactly do you mean by a case statement?

See Select Case

[masond]

HI guys

Thanks for the tip

So far this is my if formula

IIf([Sub-Source] Is Null,[Sub-Source],[How did you hear of us]) AS Channel,


iIf([Channel] in ('Internet PPC','Offer-1for3month-Jan13', 'Offer-1for3month-Jan13', 'Offer-Switch-Jan13','Phone-Offer-1for3month-Jan13','Phone-PPC-Brand','Phone-PPC-Machines', 'Phone-PPC-Merchant','Phone-PPC-ProcPayments','Phone-PPC-Terminals','Post visit BingYahoo PPC', 'Post visit Google PPC','Post visit Referrer Referred', 'PPC-Brand','PPC-CreditCard','PPC-DCC','PPC-Ecommerce', 'PPC-Machines', 'PPC-Merchant','PPC-ProcPayments', 'PPC-Terminals', 'Switcher Cashback', 'PPC-remarketing'), "PPC",

IIf([Channel] in('At Work','ClientLine - Freefor3months','£1MonthFor3','ConnectX-Online','Connectx-Print','Email','Google/Yahoo','HDC','Internet FDMS Website (SE0)','Internet Search Engine','Live Chat','New Customer','Partner Referral','Phone-Direct', 'Phone-Offer-RetraFd', 'Recommendation/Referral','Refer a Friend','RetraFd','SEO-1Monthsfor3','SEO-Switcher-Cashback', 'Phone-SEO'), "SE0", "Check")) AS [testing],


In the final if statement i need to say

If Callid>1 then update column Testing with “PPC” other wise stick with the value in “Testing”

Any ideas, how i can add the last if condition on ?

[orange]

Can you tell us in plain English -- no vba , no SQL --WHAT exactly are you trying to do?

You might find syntax and samples of functions at:
http://www.techonthenet.com/access/f...vanced/iif.php
http://www.techonthenet.com/access/f...ced/isnull.php

http://www.w3schools.com/sql/sql_in.asp