Hi,
For the life of me I can't find my past post on how to do the following formula. I have a control [catagory] which contains "assests", "liabilities" and "equity". There is a corresponding control [amount] which gvies the currency for each of the catagories. I have a report that breaks them out separately and this is working fine. I need to get the total of liabilities + equity. I've tried =([AMOUNT]="liabilities")+([amount]="equity") but the answer comes up as zero. What am I missing?

Thanks,
Leesha

2. ## Re: Additon Problem (2002)

If you know how to add each category separately you should be able to combine the formulas for liabilities and equity.

Otherwise, try something like this:
<code>
=Sum(IIf([Category="liabilities" Or [Category]="equity",[Amount],0)
</code>
Note: if you've really named the field Catagory, you should use that, of course.

3. ## Re: Additon Problem (2002)

Thanks Hans, this is exactly what I was looking for.

Leesha

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•