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.