In one field I am counting [Claim Number]. In another field I would like it to either show up as its original [Inspection] or "Miscellaneous", depending how many the count is (x).
My new [Inspection] field:
Inspection: IIf(Count([Claim Number])<2, "Miscellaneous", [Returns Table]![Inspection])
The total is (Group By)
I am receiving an error reading "Cannot have aggregate function in GROUP BY clause". How can I get this to work?
Kris