Search results

Thank you for your help, however, once again I have lost the plot a tad, could/would you elaborate when you say "assign the key value to the table via code via a form or something" I am creating a new table called call_numbers with the field name being call_number. Thanks in advance.

Thank you for your respone, I'll let you know how it goes.

The second example but starting from 300: For Jan: 08A300 08A301 08A302 etc, etc. For Feb 08B300 08B301 08B302 etc, etc. For Mar 08C300 08C301 08C302 etc, etc, Then for next year start at: For Jan 09 09A300 09A301 09A302 etc, etc. Thanks in advance for your help.

The reasoning behind this is that the call number shows at a glance what year, month it was generated and a unique number for the call out so for example: 08A300 would have been raised in 2008, in January and it's the first call number of 300, this number would then increase as more calls are...

I need to create an auto number for service calls that show the following: year as 08, 09 etc, month as a letter, Jan = A, Feb = B etc then an incremental number starting at 300 for each month/year combination. So for example: 08A300 Can anyone help me as I am stuck?