I have created a database wherein it also prints a transmittal letter. The control source for this letter is the Document Transmittal Number.



I prepared a query that is the source of the report where it asks the Document Transmittal Number to show on screen.

Within the transmittal number, several documents are to be listed, these documents should have a serial number that starts from 1, how can I incorporate this on the report.

Every time a transmittal letter is printed whether only 1 document or several documents are mentioned in that transmittal letter, the serial number always starts at 1.

please help.

thank you.

Trident