IIf(([Exchange Name]=[IMF Rates]) And ([Exchange Name]=[IMF]),[Spread Sorted (IMF)]![Excess/Deficit]+[Spread Sorted (IMF Rates)]![Excess/Deficit], FALSE)
Expr1: IIf(([Collateral Statement]![Exchange Name]="IMF Rates") And ([Collateral Statement]![Exchange Name]="IMF") And ([Collateral Statement]![Currency Basis]="Collateral Ccy") And ([Collateral Statement]![Currency]="USD"),0,999) |
(Ignore the true/false parts. That's just a placeholder until I figure out what's wrong with the language)
Basically none of these work and I'm having a hard time figuring out why. Microsoft access alludes to the problem being because I'm pulling the Exchange Name part from multiple tables, which I don't think is true. Also I want the query to return the data even if its not from both exchanges it.
I want the data to add if it is part of "IMF Rates" and "IMF", but I also want the data returned if its part of either or, not both.
Tell me what I'm doing wrong; I'm a beginner w/ no previous experience and I've no idea how to fix hah.
Thanks!
Tzames |