IIF Function

Dear Sir,

I encounteretd problem regarding with my work and its difficult for me
to fidn the coorect syntax for this problem.

Here is the sample problem:

Side Order Value
Buy 25,000.00
Sell 24,250.00
Buy 23,200.00
Buy 500.00
Sell 20,210.00

Hence, in report I want to get the total Order value if the Side =
"Buy". Also, for Side = "Sell" to get the total Order Value.

Thank your very much in advance if you could give me an idea or the
correct syntax in my part.

Kind regards.

Create a query into this table.

Type this expression into a fresh column in the Field row:
BuyAmount: IIf([Side] = "Buy", [Order Value], 0)

In the next column, in the field row:
SellAmount: IIf([Side] = "Sell", [Order Value], 0)

You can now create a report with columns for BuyAmount and SellAmount, and
total the columns if desired.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

wrote in message
oups.com...
Dear Sir,

I encounteretd problem regarding with my work and its difficult for me
to fidn the coorect syntax for this problem.

Here is the sample problem:

Side Order Value
Buy 25,000.00
Sell 24,250.00
Buy 23,200.00
Buy 500.00
Sell 20,210.00

Hence, in report I want to get the total Order value if the Side =
"Buy". Also, for Side = "Sell" to get the total Order Value.

Thank your very much in advance if you could give me an idea or the
correct syntax in my part.

Kind regards.

Or just add a text box in a Group or Report Header or Footer with a control
source like:
=Sum(Abs([Side]="Buy") * [Order Value])
=Sum(Abs([Side]="Sell") * [Order Value])
--
Duane Hookom
MS Access MVP
--

"Allen Browne" wrote in message
...
Create a query into this table.

Type this expression into a fresh column in the Field row:
BuyAmount: IIf([Side] = "Buy", [Order Value], 0)

In the next column, in the field row:
SellAmount: IIf([Side] = "Sell", [Order Value], 0)

You can now create a report with columns for BuyAmount and SellAmount, and
total the columns if desired.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

wrote in message
oups.com...
Dear Sir,

I encounteretd problem regarding with my work and its difficult for me
to fidn the coorect syntax for this problem.

Here is the sample problem:

Side Order Value
Buy 25,000.00
Sell 24,250.00
Buy 23,200.00
Buy 500.00
Sell 20,210.00

Hence, in report I want to get the total Order value if the Side =
"Buy". Also, for Side = "Sell" to get the total Order Value.

Thank your very much in advance if you could give me an idea or the
correct syntax in my part.

Kind regards.