P
Pete Sperling
I have 20 controls in a report. Each of these controls can contain either
UA, O, P1, P2, P3 (etc), N1, N2, N3 (etc), or Null. I would like to create a
separate unbound control for each type of entry that will only look at the
first letter and tell me how many times it appears in the record. i.e. If
four of the controls in the record contain N1, N2, N3, and N4, I would want
the unbound control which is looking for N? to tell me there are 4. I think
that code can be written to count these but I have no idea how to write it in
the unbound control I want to create.
Any help greatly appreciated.
UA, O, P1, P2, P3 (etc), N1, N2, N3 (etc), or Null. I would like to create a
separate unbound control for each type of entry that will only look at the
first letter and tell me how many times it appears in the record. i.e. If
four of the controls in the record contain N1, N2, N3, and N4, I would want
the unbound control which is looking for N? to tell me there are 4. I think
that code can be written to count these but I have no idea how to write it in
the unbound control I want to create.
Any help greatly appreciated.