ExcelBanter - Reference Number

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Reference Number (https://www.excelbanter.com/excel-discussion-misc-queries/73176-reference-number.html)

horseman

Reference Number

I have a database which I have a reference number field. Is there any way
that I can make the number start at 1 at the begging of each year.

CLR

Reference Number

Probably, but we need to know a little more about your Reference Number
Field, which column is it and how the numbers are created...........and if
you have a Date Column with sequential dates..................

Vaya con Dios,
Chuck, CABGx3

"horseman" wrote:

I have a database which I have a reference number field. Is there any way
that I can make the number start at 1 at the begging of each year.

All times are GMT +1. The time now is 10:37 AM.