3 Replies Latest reply on Nov 26, 2010 1:06 PM by philmodjunk

    Count for several fields...

    cheathamtech

      Title

      Count for several fields...

      Post

      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.

      Thanks!