Performing a count of specific text in report

[Bobwords]

I'm trying to create a report of devices that are being shipped, giving a total number of devices sent. I want to create a footer on the report that shows how many of each device type is being mailed monthly, but I'm not sure how I'm supposed to go about writing the syntax for it.

On any given month we'll ship 5 different items, each contained as text in the Device_Type field.



At the very bottom of the report, I'd like to get an output that shows how many of each device type way shipped. Is there a way to do something like =Count("6921", [Device_Type])? I know that isn't the right way to do it, as I've tried. Any help would be greatly appreciated!

[June7]

Did you consider using report Sorting & Grouping features with aggregate calc in group footer?

How many device types are there? In report footer section:

=Count(IIf([Device_Type]="6921",1,Null))

or

=Sum(IIf([Device_Type]="6921",1,0))

[Bobwords]

Did you consider using report Sorting & Grouping features with aggregate calc in group footer?

How many device types are there? In report footer section:

=Count(IIf([Device_Type]="6921",1,Null))

or

=Sum(IIf([Device_Type]="6921",1,0))

=Count(IIf([Device_Type]="6921",1,Null)) was exactly what I needed! Thank you so much.

If I could ask, can you help break down what each thing is doing? Just so I understand it better?

I get how count works, but why are there two IIs? Is that a different command? For the 1,Null, what exactly does that do? Assign the appearance of a 6921 a value of 1 to be counted? What does the null statement at the end do?

[June7]

The IIf() is an intrinsic function. It means "In-line If". The logic is: If condition is true, then do this, else do this. Access Help has more info on use of IIf() function.

Aggregate functions ignore Null so it does not count that record.