View Single Post
  #1 (permalink)  
Old July 24th, 2007, 02:42 AM
Odeh Naber Odeh Naber is offline
Authorized User
Join Date: Mar 2006
Location: , , .
Posts: 83
Thanks: 1
Thanked 0 Times in 0 Posts
Default Total Count of Specific Records in a Report

Hiya folks!

I am sure this is a simple one, but I just cant seem to figure it out:

I have a report that shows something similar to the following:

Hamburger Meat
Trout Fish
Beef Steak Meat
Custard Dessert
Fruit Salad Dessert
Lamb Cutlets Meat

Now what I cant seem to do is to have the report show the following summary for the above:

Number of Meat dishes: 3
Number of Fish dishes: 1
Number of Dessert dishes: 2

I have tried various versions of count and dcount, but cant seem to get it to work.

Thank you!