brendanolear
Active Member
- Joined
- Apr 26, 2008
- Messages
- 366
New to Access and unable to reconcile this query.
My current query is as follows
Name:IIF([Master]![Name1]="Alpha" OR [Master]![Name1]="Beta","Yes","No"
which gives me results as expected
I wish to amend it to:
Name:IIF([Master]![Name1]="Alpha" OR [Master]![Name1]="Beta" AND [Master]![CCode]<>"BA06","Yes","No"
To exclude any "CCodes" of "BA06"
I'm clearly missing a parameter - grateful for advice.
My current query is as follows
Name:IIF([Master]![Name1]="Alpha" OR [Master]![Name1]="Beta","Yes","No"
which gives me results as expected
I wish to amend it to:
Name:IIF([Master]![Name1]="Alpha" OR [Master]![Name1]="Beta" AND [Master]![CCode]<>"BA06","Yes","No"
To exclude any "CCodes" of "BA06"
I'm clearly missing a parameter - grateful for advice.