<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2719.2200" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=789121916-09072003><FONT color=#0000ff
size=2>Virginia,</FONT></SPAN></DIV>
<DIV><SPAN class=789121916-09072003><FONT color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=789121916-09072003><FONT color=#0000ff size=2>Are you going to
let these 20 or so users to randomly create these prefixes or are you going
to have combo boxes for them to select the prefixes from? If the later,
then it should be easy to use the DMax() function to find the last number
assigned to that prefix and then add 1 to it. If the former, you can do
the same but you have to worry about nulls if they are the first to create a
given prefix.</FONT></SPAN></DIV><!-- Converted from text/rtf format -->
<P><SPAN lang=en-us><B><FONT color=#0000ff>Charles Wortz</FONT></B></SPAN>
<BR><SPAN lang=en-us><FONT color=#0000ff>Software Development
Division</FONT></SPAN> <BR><SPAN lang=en-us><FONT color=#0000ff>Texas Education
Agency</FONT></SPAN> <BR><SPAN lang=en-us><FONT color=#0000ff>1701 N. Congress
Ave</FONT></SPAN> <BR><SPAN lang=en-us><FONT color=#0000ff>Austin, TX
78701-1494</FONT></SPAN> <BR><SPAN lang=en-us><FONT
color=#0000ff>512-463-9493</FONT></SPAN> <BR><SPAN lang=en-us><FONT
color=#0000ff>CWortz@tea.state.tx.us</FONT></SPAN> </P>
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Hollis,Virginia
[mailto:HollisVJ@pgdp.usec.com] <BR><B>Sent:</B> Wednesday 2003 Jul 09
10:52<BR><B>To:</B> 'accessD@databaseadvisors.com'<BR><B>Subject:</B> [AccessD]
Assign Document Numbers<BR></FONT></DIV>
<DIV><FONT size=2><SPAN class=789121916-09072003><FONT
color=#0000ff> </FONT></SPAN></FONT></DIV>
<DIV><FONT size=2><SPAN class=789121916-09072003> </SPAN>I've created a
database for use by a group of individuals (perhaps 20 users) in which the user
will open a form and place a request for a document number. I need a document
number to be automatically assigned at that time.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=2>An example of document numbers and their scheme are as
follows: </FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=2>DC-2101-0001</FONT></DIV>
<DIV><FONT size=2>DC-2204-0001</FONT></DIV>
<DIV><FONT size=2>DC-2301-0001</FONT></DIV>
<DIV><FONT size=2>LA-2605-0001</FONT></DIV>
<DIV><FONT size=2>LA-2605-0002</FONT></DIV>
<DIV><FONT size=2>LA-2605-0003</FONT></DIV>
<DIV><FONT size=2>NR-2605-0001</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=2>It's the last set of numbers (0001, 0002, 0003) that I wish to
have assigned according to which first two sets (DC) and (2101) are input by the
user. Like if a user inputs "DC" and "2101"....I'd like the system to
automatically assign the next available number which would be "0002". Therefore
the document number assigned would be "DC-2101-0002".</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=2><SPAN class=440174415-09072003>Also, t</SPAN>he bad thing for
me is that we have already been using this database (just one individual) and
manually assigning these numbers. I don't know how it would work out if we
suddenly put the code in. Would it acknowledge previous entries and assign the
correct number?</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=2>If <SPAN class=440174415-09072003>someone</SPAN> can help
me with this, I'd be eternally grateful.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=2><SPAN
class=440174415-09072003>Virginia</SPAN></FONT></DIV></BODY></HTML>