Counting fields showing certain data

[lgalumbres]

Hi everyone,

I have a report that shows transactions. Each transaction is different, they are either "1035" or "IRA". I can count all transaction by just counting one field, which is the transactionID field by =Count([TransactionID])

In the report, I have these fields:
- TransactionID ---- Transaction ID number.
- AccountNum ---- Client account number.
- ClientName ---- Name of client.
- 1035orIRA --- Shows the type of transaction.
- TransferredFrom/Company ---- Shows the company that transferred the transaction.

So my question is, how do I count transactions that are ONLY "IRA" and the company who transferred the transaction is NOT "AIG"? Is this possible? Any help would be great... thanks in advance.....

-Lem

 

[llkhoutx]

One method is to count in a query, using the criteria you want.

 

[lgalumbres]

Ummm ok...