Sum If

[Lynn]

Is it possible to do a SumIf calculation in an Access 2003 report (similar to
what I can do in Excel)? For example, I have various values displayed in a
Color field on my report. I would like to create a formula that will count
only the blue values.

 

[Marshall Barton]

Is it possible to do a SumIf calculation in an Access 2003 report (similar to
what I can do in Excel)? For example, I have various values displayed in a
Color field on my report. I would like to create a formula that will count
only the blue values.

=Sum(IIf(something = "blue", 1, 0))

or one of any number of various similar expressions.

BUT, that make your expression dependent on a data value.
Instead you should use a Totals type query to calculate the
count for all the different colors.