Can someone tell me what is wrong with this syntax in my query?
Code: iif [DataImport].[DisbursementCod e] & [DataImport].[ReceiptCode] is Null & [DataImport].[Asset] = “BlackRock Interest”, “Interest Income”, [DataImport].[DisbursementCod e] & [DataImport].[ReceiptCode]
MrBill
Last Activity: Apr 3 '07, 11:33 PM
Joined: Apr 3 '07
Location:
-
What is wrong with this syntax?
-
If Then Query
I have a table with three fields - DCode, RCode and Asset. The DCode and Rcode are mutually exclusive so I combine the two in a query and call the expression field "Code". Now I only have two fields in my query - Code and Asset.
Now what I need to do is the following If/then, but I am having trouble getting it to work. Here is what I want to do in regular language:
If [Code] is null and [Asset] = BL, then...
No activity results to display