autonumber
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » Autonumber

Autonumber

resolvedResolved · Low Priority · Version 2003

replyReply 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?

For upcoming training course dates see: Pricing & availability

replyReply 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.

 

Please browse our web site to find out more about
microsoft access 2002 training and other Microsoft training courses.

Access tip:

Zoom feature for queries

If youare working on on query design and creating a calculated field, it can be hard to view the whole statement. You can hold the shift key down and press F2, to show the zoomed up version of the query field

View all Access hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard