sum a total where condition... 1

[adsfx]

Hi,
I have a report that displays all records in a table.
the report is populated by an underlying query.
I have textboxes that sum ALL the totals, but I need to know how to sum totals on condition of a field in a table.

Is this best done as an expression in a textbox?:
=IIf([cattype_id]=2,Sum([amount]))

or would you suggest an alternative?

 

[PaulBricker]

Your thinking in the right direction but you may need to modify your expression something like this

=Sum(IIf([cattype_id] = 2, [Amount],0))

This should give you what you are looking for.

Paul

 

[adsfx]

cheers Paul...jus what i needed!