I have a question about numbering rows of data in a Access table or query. I do not want to number each row but want to number each time a serial number appears in a table or query. I have already sorted by date and would like to have a reference in the table of each appearance of a Serial number. Below is an example.
<colgroup><col width="63" style="width: 47pt; mso-width-source: userset; mso-width-alt: 2247;">
<col width="135" style="width: 101pt; mso-width-source: userset; mso-width-alt: 4807;">
|Serial ||Order of Appearance|