I have this table called Facturació:
enter image description here
The image shows the result i’d like to achieve, that is, the column Nº Factura (Invoice number) is a concatenation of the year taken from the DataFactura field (year(DataFactura)
) and an incremental number that resets to 1 when year(DataFactura)
changes. How can I achieve this?
Thanks for your help!
New contributor
Dani Valverde is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.