Counting Text Fields In A Report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

If I have product names I want to count in a report what would expression
look like. For example if I have 4 products I sell Widgets, zippers, buttons
& laces. In the form their in a combo box. If I want to found out how many
Widgets I sold what should I do? Thanks.
 
If I have product names I want to count in a report what would expression
look like. For example if I have 4 products I sell Widgets, zippers, buttons
& laces. In the form their in a combo box. If I want to found out how many
Widgets I sold what should I do? Thanks.
Click to expand...

If the bound column of the combo box is a Text datatype:
=Sum(IIf([Product] = "Widgets",1,0)
=Sum(IIf([Product] = "Zippers",1,0)
etc.
 
Back
Top