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;">
<tbody>
</tbody>
Serial | Order of Appearance |
A-360451 | 1 |
A-360451 | 2 |
A-360642 | 1 |
A-360642 | 2 |
A-362214 | 1 |
A-362214 | 2 |
A-365228 | 1 |
A-365228 | 2 |
A-365446 | 1 |
A-365446 | 2 |
A-366077 | 1 |
A-366077 | 2 |
A-366077 | 3 |