Use array to qualify to columns
Posted by jsavery on December 20, 2001 8:28 AM
I have to columns, one containg a district, the second containg a date.
I would like to get a count of those districts that have a date enterd in the column.
I have tried to get the AND function to do this, qualifying the district being equal and the date being > 0, but I cannot get this to work.
Result: 001 = 1, 002 = 2