Hello everyone,
First of all allow me to say that I am very new to all this. I just started my company and took the decision to avoid getting involved with Microsoft as I feel uncomfortable and an uncertainty with the costs. So excuse if my question shows a bit of naivety.
We have an ID field in our database of expenses, as well as a year field. So when we put an new entry it takes a new ID (integer) and then a year entry. However we want to have a field which is the document (expense) Ref No. which looks something like Exp1601, where Exp is a string (expense) 01 is the ID and 16 is the year. Is there a way to have a field that is basically a concatenation of these two other fields?
Many thanks in advance for any help and for your time.