ASP.NET

Using IIF in Ms Access RSS

4 replies

Last post Nov 12, 2012 09:58 AM by masteixeira

‹ Previous Thread|Next Thread ›

- Reply
masteixeira

0 Points

2 Posts

Using IIF in Ms Access

Nov 09, 2012 04:43 PM|LINK

Can anyone please tell me what is wrong with this expression.

"SELECT UserID, Username, IIF (IsNull(SELECT Sharewith FROM SharedDocuments WHERE DocumentCode = 'TEXT' AND DocumentAuto=3 AND ShareWith = UserID), True, False) AS IsShared

FROM Users

WHERE UserID <>'Test'

ORDER BY UserName, IsShared;"

Thank You

ATE
- Reply
spapim

Contributor

2446 Points

368 Posts
Re: Using IIF in Ms Access

Nov 09, 2012 05:33 PM|LINK
Try:
```
IIF (Exists(SELECT Sharewith FROM SharedDocuments
            WHERE DocumentCode = 'TEXT' AND
                  DocumentAuto=3 AND
                  ShareWith = UserID), False, True) as IsShared
```
Hope this helps.
www.imoveisemexposicao.com.br/imoveis-venda-são_paulo-residencial
www.imobiliariasemsuzano.com.br
- Marked as answer by decker dong - msft on Nov 15, 2012 12:27 AM
- Reply
oned_gk

All-Star

31055 Points

6356 Posts
Re: Using IIF in Ms Access

Nov 10, 2012 02:09 AM|LINK
Joint the tables with show all [Users] rows
```
IIF (SharedDocuments.DocumentCode = 'TEXT' AND SharedDocuments.DocumentAuto=3, True, False) AS IsShared
```
Programming to simplify, dont look for hard way
- Edited by oned_gk on Nov 10, 2012 02:11 AM
- Edited by oned_gk on Nov 10, 2012 02:12 AM
- Edited by oned_gk on Nov 10, 2012 02:13 AM
- Edited by oned_gk on Nov 10, 2012 02:14 AM
- Marked as answer by decker dong - msft on Nov 15, 2012 12:27 AM
- Reply
Decker Dong ...

All-Star

118619 Points

18779 Posts
Re: Using IIF in Ms Access

Nov 10, 2012 05:36 AM|LINK
masteixeira
IIF (IsNull(SELECT Sharewith FROM SharedDocuments WHERE DocumentCode = 'TEXT' AND DocumentAuto=3 AND ShareWith = UserID), True, False) AS IsShared

Hi,

Please quote the As…… into the pair of "()":
```
SELECT UserID, Username, (IIF(IsNull(SELECT Sharewith FROM SharedDocuments WHERE DocumentCode = 'TEXT' AND DocumentAuto=3 AND ShareWith = UserID), True, False)) AS IsShared
```
- Edited by decker dong - msft on Nov 10, 2012 05:36 AM
- Reply
masteixeira

0 Points

2 Posts

Re: Using IIF in Ms Access

Nov 12, 2012 09:58 AM|LINK

Thank you all for your time.