Help with an IIF expression

[Yappy]

My database is similar to a checkbook register and contains the following
fields:
Amount
Combo box with the expense categories of Housing, Medical, Personal

I have a report that gives me a monthly total for each of these categories
and a grand total of all categories for the month. However, I need help in
calculating a monthly total for Medical and Personal combined.

Please help me with the expression. I want to add a text box to my report
to show the results of this expression.

Thank you!

 

[Duane Hookom]

You can create a hard-coded expression like:
=Sum(Abs([ExpCat] IN ("Medical","Personal")) * [Amount])

 

[Yappy]

Duane,
Thanks so much for your help. I used your expression and it worked
perfectly. I was trying to come up with an IIF statement and making it
harder than it actually was.

Yappy

You can create a hard-coded expression like:
=Sum(Abs([ExpCat] IN ("Medical","Personal")) * [Amount])

--
Duane Hookom
Microsoft Access MVP

My database is similar to a checkbook register and contains the following
fields:
Amount
Combo box with the expense categories of Housing, Medical, Personal

I have a report that gives me a monthly total for each of these categories
and a grand total of all categories for the month. However, I need help in
calculating a monthly total for Medical and Personal combined.

Please help me with the expression. I want to add a text box to my report
to show the results of this expression.

Thank you!