98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » Autonumber
Autonumber
Resolved · Low Priority · Version 2003
Wed 16 Jun 2010, 12:02Delegate Andrew said...
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?
Wed 23 Jun 2010, 10:06Trainer Jacob said...
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
Tue 29 Jun 2010: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Create calculated fields that work out your ageYou can uset eh year function to work out the year from NOW function and then subtract it with your date of birth type field |
