Exclude where columns match

[homage]

I have a table that lists Cost Center, Partner, and Cost. I need a query to sum the cost when Cost Center and Partner do not match. How can I write that expression?

 

[jdraw]

Can you tell us about your database? What other tables are involved?

 

[plog]

This will do exactly as you asked:

SELECT SUM(IIF([Cost Center] <> [Partner], [Cost], 0) AS Total
FROM YourTableNameHere

Be sure to replace 'YourTableNameHere' with the name of your table.

 

[pbaldy]

Or

SELECT Sum(Cost) AS TotalCost
FROM TableName
WHERE [Cost Center] <> [Partner]

which may be more efficient.

 

[pbaldy]

Or

SELECT Sum(Cost) AS TotalCost
FROM TableName
WHERE [Cost Center] <> [Partner]

which may be more efficient.