I have an access database where it has a main form and a sub form within. The sub form can have many records usually 12. These 12 have the same trace code (as we call it) example 09B15PF-UF which is on the main form. Now the difference of each record is the suffix at the end. So each record on the sub form has an AA, AB, AC, AD, AE, AF, AG, AH, AI, AJ, AK, AL and so on. I have a report that is linked to these which is a cert of conformance. How can I make a field on the report which will take the AA (the first suffix) thru AL (the last suffix). Right now if I put the suffix on the report it only puts AA.
thanks for the help