clover10
asked on
MS Access "IF" and "Or" Query
I am trying to add an "or" to a query, this is what I currently have:
also tried:
Sum(IIf(([DExtract].[ValTT]<>"Payments") OR ([DExtract].[ValTT] <> "Invoices"),[DExtract].[AmountTBCAPB],0,0)) AS [TEST]
also tried:
Sum(IIf(([DExtract].[ValTT]<>"Payments") AND ([DExtract].[ValTT] <> "Invoices"),[DExtract].[AmountTBCAPB],0,0)) AS [TEST]
What results are you hoping for?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I realized I needed to do "AND" and not "OR" but thank you that worked!!!
ASKER
Great! Thanks!