<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META content="MSHTML 5.00.3314.2100" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Arial size=2><SPAN class=800250212-15052003>I need to set up a
way to assign sequential numbers based on different
criteria.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=800250212-15052003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=800250212-15052003>The first part of
the number is a document number, it can be either AB1234 or CD6789, the
next part is for the Engineering section (C for Civil, M-Mechanical,
E-Electrical). So the numbering scheme would be:</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=800250212-15052003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=800250212-15052003>AB1234-C001
(tracking number - section, sequential number)</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=800250212-15052003>AB1234-C002</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=800250212-15052003>AB1234-M001</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=800250212-15052003>CD6789-E001</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=800250212-15052003><FONT face=Arial
size=2><SPAN
class=800250212-15052003>CD6789-E002</SPAN></FONT></SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=800250212-15052003><FONT face=Arial
size=2><SPAN class=800250212-15052003><FONT face=Arial size=2><SPAN
class=800250212-15052003>CD6789-M001</SPAN></FONT></SPAN></FONT></SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=800250212-15052003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=800250212-15052003>The numbers also
contain revisions and change letters. I</SPAN></FONT><FONT face=Arial
size=2><SPAN class=800250212-15052003>f I want the next Civil number for
document tracking number AB1234, it would be:</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=800250212-15052003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=800250212-15052003>AB1234-C003, Rev 0,
Ch 0 (document number - section, sequential number, revision,
change)</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=800250212-15052003>then AB1234-C003,
Rev 0, Ch A</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=800250212-15052003>or AB1234-C003, Rev
1, Ch 0</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=800250212-15052003>AB1234-C003, Rev 1,
Ch A</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=800250212-15052003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=800250212-15052003>I thought if I could
have the form select the tracking number & the section, I could use a query
to designate what the next sequential number would be based on the tracking
number & the section. Then I couldn't get the two different criteria to
work together. </SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=800250212-15052003></SPAN></FONT><FONT
face=Arial size=2><SPAN class=800250212-15052003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=800250212-15052003> ' Find
the record that matches the control.<BR>
Me.RecordsetClone.FindFirst "[DocID] = '" & Me![cboDocNum] & " AND
[Section] = " & Me![cboDocNum] & "'"</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=800250212-15052003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=800250212-15052003>Now I got to
wondering how I would handle the Revision & Change Letter. Any ideas how I
can put all this together?</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=800250212-15052003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=800250212-15052003>Virginia<BR></DIV></SPAN></FONT></BODY></HTML>