Andrew has attended:
Access Introduction course
Autonumber
Is it possible to create an autonumber with a specific format? For example currently our reference numbers are in the following format
MI1234 is it possible to set this autonumber up?
Also, for a different number we use the date of the enquiry followed by A B or C for the 1st, 2nd or 3rd query of that day so the second query on 15th June 2010 would be listed
100615B is it possible to set this up?
RE: Autonumber
Hi Andrew
Thanks for your post which we have reviewed. We are reasonably confident a solution can be found for this however to reach it will be beyond the scope of this forum.
We will need to see your working files and then be able to get back to you with a scope of work, hours required and related trainer costs to complete.
If you would like to progress this please reply to my email.
Kind regards
Jacob