No announcements
Found 3528663 threads
-
0 VotesMS Access IIF and SQL Server Case statement
On which version of SQL-Server are you working and what tool are using to create your query?Answered | 3 Replies | 14202 Views | Created by Zayas1 - Thursday, January 13, 2011 8:37 PM | Last reply by Sylvain Lafontaine - Friday, January 14, 2011 7:39 PM
-
0 Votes
Having trouble converting a MS Access IIF statement into SQL Sever 2012
You can use IIF directly with SQL Server 2012: --SQL Server 2012 SELECT IIf(a.Answered | 2 Replies | 619 Views | Created by SmithBrianScott - Friday, February 20, 2015 4:17 PM | Last reply by Jingyang Li - Friday, February 20, 2015 5:12 PM -
3 Votes
convert access IIF into sql
The IIF in Access transforms into CASE WHEN statements in T-SQL.Answered | 13 Replies | 7267 Views | Created by Izmzusa - Monday, November 23, 2009 8:02 PM | Last reply by Justanewone - Monday, November 23, 2009 11:06 PM -
3 Votes
IIf or switch function access 2007
If you use False or omit the second argument, you get the full names January, February etc.Answered | 7 Replies | 2871 Views | Created by ashiv - Monday, July 23, 2012 7:36 PM | Last reply by ashiv - Monday, July 23, 2012 8:12 PM -
1 Votes
Converting an Access IIf statement
Hi ProfessorFudger, In your scenario, you could also specify the expression in the report like below: =IIF(Fields!Answered | 4 Replies | 714 Views | Created by ProfessorFudger - Tuesday, April 14, 2015 12:04 PM | Last reply by Qiuyun Yu - Wednesday, April 15, 2015 9:41 AM -
0 Votes
IIf Function
I used this in Design View and it worked perfectly: If you want to build it in design view, you can either apply a criterion like this to the StaffID ...Answered | 5 Replies | 443 Views | Created by Gordon Swan - Sunday, January 21, 2018 4:42 PM | Last reply by Gordon Swan - Tuesday, January 23, 2018 1:18 AM -
0 Votes
iif function give error on '='
Hi You're looking for the MS Access function.Answered | 2 Replies | 4800 Views | Created by sakaar - Thursday, December 30, 2010 9:44 AM | Last reply by Jason V Campbell - Thursday, December 30, 2010 9:55 AM -
0 Votes
IIf
Hi Jaciii4455, According to your description, you need to update the status field using IIF function, right?Answered | 1 Replies | 460 Views | Created by Jaciii4455 - Monday, May 16, 2016 10:46 PM | Last reply by Charlie Liao - Tuesday, May 17, 2016 1:51 AM -
0 Votes
using iif in ssrs
You can try the expression below: =IIF(CStr(Fields!Answered | 2 Replies | 2093 Views | Created by Karuna Kumar.C-Wipro_MSBU - Friday, August 10, 2012 11:38 AM | Last reply by Mike Yin - Friday, August 17, 2012 9:48 AM -
2 Votes
Ms Project 2007 Nested IIF statements
I will use this for future template developments. :) Joshua CullenAnswered | 6 Replies | 8863 Views | Created by Jobe78 - Monday, May 7, 2012 4:10 AM | Last reply by Jobe78 - Tuesday, May 8, 2012 2:07 AM -
3 Votes
Using IN (or similar) with IIF
Then use Par1 instead of your IIF statement =iif(Parameters!Answered | 8 Replies | 4063 Views | Created by Ded_innit - Thursday, August 4, 2011 10:32 AM | Last reply by Naomi N - Wednesday, October 5, 2011 8:41 PM -
4 Votes
IF vs IIF
In this code, I have four ordinary, yet useful forms of using IIf in an effective manner, or so I believe.Answered | 26 Replies | 41796 Views | Created by Mahmoud Hakeem - Thursday, August 13, 2009 5:11 PM | Last reply by B_E_L - Friday, February 4, 2011 1:37 PM -
1 Votes
IIF function?
Instead of IIF, use CASE...WHEN...THEN...ELSE...END.Answered | 2 Replies | 4125 Views | Created by DarrellDoesData - Wednesday, September 9, 2009 7:26 PM | Last reply by DarrellDoesData - Wednesday, September 9, 2009 8:16 PM -
16 Votes
#Error using IIF and divide by zero
I am getting an error in a calculated field that could potentially divide by zero, even though I'm using an IIF.Answered | 20 Replies | 94949 Views | Created by Lawrence Parker - Friday, January 19, 2007 3:56 PM | Last reply by Nora Leyva - Wednesday, September 4, 2019 4:59 PM -
5 Votes
IIF Function
Are you working with Microsoft Access?Answered | 7 Replies | 2166 Views | Created by Danny Gan - Thursday, July 14, 2011 3:20 AM | Last reply by Paul P Clement IV - Thursday, July 14, 2011 12:48 PM -
0 Votes
IIF(IsNull) formula trouble
Dirk Goldgar, MS Access MVP Access tips: www.datagnostics.com/tips.htmlAnswered | 6 Replies | 14230 Views | Created by Zaidenpr - Wednesday, June 1, 2016 6:54 PM | Last reply by Ibrahim El Badri Idris - Tuesday, March 12, 2019 10:18 AM -
0 Votes
iif
Please refer to the expression below: =Sum(IIF(Fields!Answered | 2 Replies | 1476 Views | Created by Ryan McBee - Thursday, March 6, 2014 9:41 PM | Last reply by Alisa Tang - Friday, March 7, 2014 9:50 AM -
0 Votes
Use Iif function for underlaying row
I hope this will help Many thanks Syed ...Answered | 3 Replies | 3041 Views | Created by THensbroek - Friday, April 27, 2012 7:51 AM | Last reply by Syed Qazafi Anjum - Saturday, April 28, 2012 2:14 AM -
0 Votes
iif statement
The function is called IIf, not iff.Answered | 1 Replies | 1434 Views | Created by Pdenise - Thursday, December 27, 2012 3:17 PM | Last reply by Hans Vogelaar MVP - Thursday, December 27, 2012 3:34 PM -
0 Votes
IIF STATEMENT
In case if you want to have nested IIFs, then IIF(<Condition 1>, (IIF(<Condition 2>, <True part>, <False part>)), <False ...Answered | 3 Replies | 4269 Views | Created by shimam - Thursday, August 5, 2010 2:05 AM | Last reply by Phaneendra Babu Subnivis - Thursday, August 5, 2010 4:19 AM - Items 1 to 20 of 3528663 Next ›
No announcements
