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!