How to make a condition for making a SUM - Correction

[Dirk Goossens]

Hello

Is there an alternative for the Excel-function "SumIF" in Access?
Why?

I have one table with profits and expenses.
First field, description (text): indication like "Expense" or "Profit"
Second field (numerical): the amount

It's easy to make a total and sub totals in a report. Even the wizard can do
this.

Description Amount
Income A 100
Income B 100
Income C 100
Sum(Amount) 300

Expense A 100
Expense B 100
Sum(Amount) 200

Sum(Amount) 500 That's what I get right now.

What I like to compute: Sum(Income) minus Sum(Expense).
So the result should be 100 instead of 500.

How to make the calculation "Income" minus "Expense"?

Thanks !!!

Dirk Goossens
Office: [phone]
Mobile: [phone]
Vrij Instituut Sint-Lucas
Gelukstede 2 - BE- 9700 Oudenaarde

[Chuck Grimsby]

Yes.
Because Access is a database, not a spreadsheet.

In Jet SQL, you could use either the IIF function or the Switch
function.

On Thu, 1 Dec 2005 11:01:41 +0100, "Dirk Goossens" <di*****@skynet.be>
wrote:

Is there an alternative for the Excel-function "SumIF" in Access?
Why?
I have one table with profits and expenses.
First field, description (text): indication like "Expense" or "Profit"
Second field (numerical): the amount
It's easy to make a total and sub totals in a report. Even the wizard can do
this.
Description Amount
Income A 100
Income B 100
Income C 100
Sum(Amount) 300
Expense A 100
Expense B 100
Sum(Amount) 200
Sum(Amount) 500 That's what I get right now.
What I like to compute: Sum(Income) minus Sum(Expense).
So the result should be 100 instead of 500.
How to make the calculation "Income" minus "Expense"?

--
Drive C: Error. (A)bort (R)etry (S)mack The Darned Thing

[paii, Ron]

"Dirk Goossens" <di*****@skynet.be> wrote in message
news:43***********************@news.skynet.be...

Hello

Is there an alternative for the Excel-function "SumIF" in Access?
Why?

I have one table with profits and expenses.
First field, description (text): indication like "Expense" or "Profit"
Second field (numerical): the amount

It's easy to make a total and sub totals in a report. Even the wizard can do this.

Description Amount
Income A 100
Income B 100
Income C 100
Sum(Amount) 300

Expense A 100
Expense B 100
Sum(Amount) 200

Sum(Amount) 500 That's what I get right now.

What I like to compute: Sum(Income) minus Sum(Expense).
So the result should be 100 instead of 500.

How to make the calculation "Income" minus "Expense"?

Thanks !!!

Dirk Goossens
Office: [phone]
Mobile: [phone]
Vrij Instituut Sint-Lucas
Gelukstede 2 - BE- 9700 Oudenaarde

sum(iif([indication]="Profit",[Amount],-[Amount]))