Hi All,
First off I have no SQL experience so I'm hoping to be able to do this using expression builder in a query. Here is what I'm trying to do:
I have two tables Investigation (parent) and Account(child).  I'm trying to summarize the results of all the account statuses that fall under an investigation by using a multiple IIF stmt but I cant seem to group it at the investigation level -

IvestigationID AccounTRefNum AccountNum AccountClassification
444 1 1111 Unusual
444 2 2222 Unconfirmed
444 3 55555 Not Fraud
444 4 3333 Unusual
444 5 4444 Not Fraud

The result should be Unusual.

Here is the expression I have but cant seem to group it at the Investigation level:
IIf([Tb_Accounts].[AccountClassification]="Fraud","FRAUD",IIf([Tb_Accounts].[AccountClassification]="Unusual","UNUSUAL",IIf([Tb_Accounts].[AccountClassification]="Unconfirmed","UNCONFIRMED",IIf([Tb_Accounts].[AccountClassification]="Not Fraud","NOT FRAUD","REVIEW"))))

I'm sure this is easy if I knew sql but I cant seem to find anything online.  Any help would be GREATLY appreciated.
Nat

---

Reply from Alex Hedley:

Why not just create a Report
Then add a Grouping and Sorting Level and add the Account Classification as a Group, then you can see each type together.