Thanks RuralGuy but the link that you provided is useful if I wanted to create a continuous sequential number which doesn't help in my situation. Because when the date changes it just continues the sequence instead of restarting it, since, it looks for the highest value.
Hello, I am new to access and I don't know if this has been posted before but I haven't been able to find anything that can help me.
Basically what I have is a database for tracking/logging parcels that arrive to the office. I want to be able to generate a reference number based on the date of...