Help with an IIF expression

Y

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!
 
D

Duane Hookom

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

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

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

--
Duane Hookom
Microsoft Access MVP


Yappy said:
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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top