Hi,
I'm building a database for a small business. I have a table tblInvoices with a field InvoiceNumber. Currently this is Short text, because invoices are “numbered” with a combination of letters and numbers – R07-2017 for example. I’m planning on changing that to a format like 20180007, among...