My Assistant
Site Message
(Message will auto close in 2 seconds)
 Iif Isnull Still Returning Blank Field
|
|
 Apr 6 2012, 02:33 PM
Post
#1
|
|
|
UtterAccess Member Posts: 42  |
I have a query that I am using an IIf IsNull statement in 3 different fields. The issue that I am having is that even with the IIf IsNull, I am still receiving a blank field in the query results. Here is the sql for the query:
CODE SELECT qrySecurityYesNoNA.Site, qrySecurityYesNoNA.Date, IIf(IsNull(qrySecurityYesNoNA![Security Yes]),0,qrySecurityYesNoNA![Security Yes]) AS [Security Yes], IIf(IsNull(qrySecurityYesNoNA.[Security No]),0,qrySecurityYesNoNA.[Security No]) AS [Security No], IIf(IsNull(qrySecurityYesNoNA![Security N/A]),0,qrySecurityYesNoNA![Security N/A]) AS [Security N/A] FROM qrySecurityYesNoNA GROUP BY qrySecurityYesNoNA.Site, qrySecurityYesNoNA.Date, IIf(IsNull(qrySecurityYesNoNA![Security Yes]),0,qrySecurityYesNoNA![Security Yes]), IIf(IsNull(qrySecurityYesNoNA.[Security No]),0,qrySecurityYesNoNA.[Security No]), IIf(IsNull(qrySecurityYesNoNA![Security N/A]),0,qrySecurityYesNoNA![Security N/A]); Any ideas? |
 |
 
|
 |
Replies
|
Apr 6 2012, 03:13 PM
Post
#2
|
|
|
UtterAccess VIP Posts: 6,170 From: Bethesda, MD USA |
|
|
|
|
Posts in this topic
TheDude76 Iif Isnull Still Returning Blank Field Apr 6 2012, 02:33 PM
RAZMaddaz Have you tried using the Len function instead? He... Apr 6 2012, 02:59 PM TheDude76 Thanks RAZ. That worked!! Apr 6 2012, 03:12 PM
 |
 |
Jump To Forum:
|
Go to Top · Lo-Fi Version | Time is now: 19th May 2013 - 06:03 PM |