View Single Post
  #2 (permalink)  
Old July 24th, 2007, 06:51 AM
mmcdonal mmcdonal is offline
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

Create your text boxes for each ingredient, then add this sort of thing:

=Sum(IIf([Category]="Meat",1,0))

This says, if the category value is "meat" then add one to the counter, otherwise add 0.

Also,

=Sum(IIf([Category]="Fish",1,0))
=Sum(IIf([Category]="Dessert",1,0))

etc.

Did that help?

mmcdonal
Reply With Quote