Apr 7, 2003 #1 V vellaima Well-known member Joined Jan 29, 2003 Messages 109 Hi, Can anyone please tell me IIF(ISNULL) for Yes/No DataType in MS-ACCESS. Please do help me out.
Apr 7, 2003 #2 Robby Moderator Joined Nov 17, 2002 Messages 3,461 Location Montreal, Ca. User Rank *Expert* What is your question?
Apr 7, 2003 #3 V vellaima Well-known member Joined Jan 29, 2003 Messages 109 SQL="Select modified from ABC" Here modified is of datatype Yes/No in MS-ACCESS. How to write IIF(ISNULL) Statement for this column?
SQL="Select modified from ABC" Here modified is of datatype Yes/No in MS-ACCESS. How to write IIF(ISNULL) Statement for this column?
Apr 7, 2003 #4 hog Well-known member Joined Mar 17, 2003 Messages 984 Location UK I think youll find just checking to see if it is true or false will suffice
Apr 7, 2003 #5 V vellaima Well-known member Joined Jan 29, 2003 Messages 109 Hog, i am using abc table as left join. In that case how to go abt for that?
Apr 8, 2003 #6 R Raju Member Joined Mar 26, 2003 Messages 16 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
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
Apr 8, 2003 #7 M melegant Well-known member Joined Feb 2, 2003 Messages 52 Location NY nm Last edited by a moderator: Apr 8, 2003
Apr 8, 2003 #8 V vellaima Well-known member Joined Jan 29, 2003 Messages 109 I have found out the solution. It should be Code: iif([modified] Is Null, False, True)
Apr 8, 2003 #9 R Raju Member Joined Mar 26, 2003 Messages 16 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
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
Apr 8, 2003 #10 V vellaima Well-known member Joined Jan 29, 2003 Messages 109 I think the SQL which i have found it is a better solution. Since i am binding it to a checkbox inside ASP Repeater.
I think the SQL which i have found it is a better solution. Since i am binding it to a checkbox inside ASP Repeater.
Apr 8, 2003 #11 R Raju Member Joined Mar 26, 2003 Messages 16 ok.. for checking null and assigning false..instead of that you can check = false...it should work...chk it out ...let me know thanx
ok.. for checking null and assigning false..instead of that you can check = false...it should work...chk it out ...let me know thanx
Apr 8, 2003 #12 R Raju Member Joined Mar 26, 2003 Messages 16 sql ..? iif([modified] Is Null, False, True) are you are using this in SQL statements ?
Apr 8, 2003 #14 R Raju Member Joined Mar 26, 2003 Messages 16 re:sql will you copy the sql..and the code where you are chking...
Apr 8, 2003 #15 Robby Moderator Joined Nov 17, 2002 Messages 3,461 Location Montreal, Ca. User Rank *Expert* Raju, take look 6 posts up... Vidhya found the solution already.
