AnsweredAssumed Answered

Summary field question

Question asked by Charlie999 on Dec 18, 2011
Latest reply on Dec 19, 2011 by philmodjunk


Summary field question


In my database i have a field with values "Meal" & "No Meal".  When i view in list view I would like a summary field in the header showing how many meals are required.  What would be the easiest way to do this?  if i just simply have a Summary field counting entries it will count how many records there are with a value in that field but how can i ge it to count only "Meal"

One option I thought about was the to have the Original field with Meal or No Meal and then a calculated field with a simple Case or If function reading the Meal or No Meal field resulting in a number 1 or 0.  Then the main summary field showing the sum of the counting field.

Is that the simplst?