Count instances in a record on a report
Posted on 2014-01-11
On a report I have three fields. Named Field1, Field2, and Field3. Each of them can have a combination of TWO letters. For example, AB, CD, EF, DU, GH and so forth. (Note, There may be only one entry or two or three)
Also on the report I have a 4th field named txtCount. This field has to count the number of the previous fields that have combinations of letters NOT INCLUDING "AE" or "DC".
In other words, let's use two record examples:
Record 1: Field1 displays EF, Field2 displays GH, Field 3 displays CD. So for that record txtCount would be 3.
Record s: Field1 displays DU, Field2 displays AE, Field 3 displays DC. So for that record txtCount would be 1. (Because fields 2 & 3 displayed "AE" or "DC".
What is the code or control source for txtCount?