AnsweredAssumed Answered

Count for several fields...

Question asked by cheathamtech on Nov 25, 2010
Latest reply on Nov 26, 2010 by philmodjunk


Count for several fields...


This is my first time to try to use the "Count" function...

I need a count (a number) for how many records I have that have STATUS field = "Open" and REPAIR field = "Computer" and LOCATION = "Site 005"

Is this right?  I need to create a new field which will hold the count for all the open orders for computer repairs at Site 5...  But how do I write that formula...  seems I get errors no matter how I try to code it.