Next Issue?!

From: Daniel (Daniel_at_discussions.microsoft.com)
Date: 06/17/04 

Date: Thu, 17 Jun 2004 10:28:01 -0700

Hello,

How can I generate the next drawing issue based on an existing issue?
It should always be the next letter in the alphabet

for instance:
I have a table "Drawing History Tbl" which has three columns (ID, Drawing Number, Drawing Issue). I would like when the user click the command button that it would create a new entry in that table at the next logical issue.

thus if the greatest issue for that specific drawing number was B00 it would create an entry for C00, if the greatest issue for that specific drawing number was B03 it would create an entry for C00,if the greatest issue for that specific drawing number was AH00 it would create an entry for AI00 and so on ...

Thank you

Daniel