Count question

[ptrifile]

I have a report that is run from a query. I have a field that reports a "broad Category" say cat1, cat2, cat3. I would like to only include in the report how many times each categories were chosen. I have tried using the following:
=Count(Abs([broad_category]="cat1"))

But that just gives me a total count of the "broad category" and not the sum or count of cat1. can someone please suggest a different method.

Thanks!!
Paul

 

[traingamer]

You can group by "broad category" (in the grouping and sorting section) and sum in the footer fro that section.

Other ways to do it really depend on what other data is being displayed, etc.

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill

 

[dhookom]

Paul,
You were close. I think you want:
=Sum(Abs([broad_category]="cat1"))


Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]