Access Data Project Help --- IIF Statement

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am good at Access but know little about Access Data Projects.
I have some queries I am converting using IIF statemenets. What is the best
approch for using IIF in a SQL Server view ?
 
You can use Case:

Case when Field1='A' then 'choice1' else 'choice2' end
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IIF Statement 3
Nested IIf Statement 6
ACCESS - how do I apply a IIF = statement without parameter value prompt. The two column comparison is count 1
iif expected end of statement 2
Multiple iif challenge 2
Access MS Access 2010 IIF statement to check if one date is in or out of range of two other dates (fields) 0
IIf Statement In an Update Query 3
Access Query problem 1

Back
Top