IIF(ISNULL) for Yes/No DataType

[vellaima]

Hi,

 

Can anyone please tell me IIF(ISNULL) for Yes/No DataType in MS-ACCESS. Please do help me out.

[Robby]

What is your question?

[vellaima]

SQL="Select modified from ABC"

Here modified is of datatype Yes/No in MS-ACCESS.

How to write IIF(ISNULL) Statement for this column?

[hog]

I think you'll find just checking to see if it is true or false will suffice

[vellaima]

Hog, i am using abc table as left join. In that case how to go abt for that?

[Raju]

yes/no column

 

I think null is not applicable for this column,If selected yes or no,

if its no you have to take as null.(Or the default value differs)

 

Raju

[melegant]

nm Edited April 8, 2003 by melegant

[vellaima]

I have found out the solution.

It should be

iif([modified] Is Null, 'False', 'True')

[Raju]

You can directly check

 

If modified = True then..........if modified having value

 

If modified = False then........if modified not having value.

 

if its false is null.....else true...

 

let me know

[vellaima]

I think the SQL which i have found it is a better solution. Since i am binding it to a checkbox inside ASP Repeater.

[Raju]

ok..

 

for checking null and assigning false..instead of that you can check = false...it should work...chk it out ...let me know

 

thanx

[Raju]

sql ..?

 

iif([modified] Is Null, 'False', 'True')

 

are you are using this in SQL statements ?

[vellaima]

Yes.

[Raju]

re:sql

 

will you copy the sql..and the code where you are chking...

[Robby]

Raju, take look 6 posts up... Vidhya found the solution already.