<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<TITLE>Message</TITLE>
<META content="MSHTML 6.00.2800.1170" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><SPAN class=225511712-19052003><FONT face=Arial color=#0000ff size=2>I
played with your problem and came up with a "solution", but then re-read your
note and discovered that I had missed part of the problem. The phrase "grouping
sort" confuses me. Do you mean something like this:</FONT></SPAN></DIV>
<DIV><SPAN class=225511712-19052003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=225511712-19052003><FONT face=Arial color=#0000ff
size=2>PK FK
YourColumn</FONT></SPAN></DIV>
<DIV><SPAN class=225511712-19052003><FONT face=Arial color=#0000ff
size=2>1 1 10</FONT></SPAN></DIV>
<DIV><SPAN class=225511712-19052003><FONT face=Arial color=#0000ff
size=2>2 1 20</FONT></SPAN></DIV>
<DIV><SPAN class=225511712-19052003><FONT face=Arial color=#0000ff
size=2>3 2 10</FONT></SPAN></DIV>
<DIV><SPAN class=225511712-19052003><FONT face=Arial color=#0000ff
size=2>4 2 20</FONT></SPAN></DIV>
<DIV><SPAN class=225511712-19052003><FONT face=Arial color=#0000ff
size=2>5 3 10</FONT></SPAN></DIV>
<DIV><SPAN class=225511712-19052003><FONT face=Arial color=#0000ff
size=2>6 1 40</FONT></SPAN></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=225511712-19052003>If so, you're right, it is a little tricky. In the
sample above, you need to find the largest value in YourColumn where the FK is
equal to the FK you are inserting. Is that what you
need?</SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=225511712-19052003></SPAN></FONT></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=225511712-19052003></SPAN>A<SPAN
class=225511712-19052003>rthur</SPAN></FONT></FONT></FONT></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B>
accessd-bounces@databaseadvisors.com
[mailto:accessd-bounces@databaseadvisors.com] <B>On Behalf Of </B>Karen Feller
Nicholson<BR><B>Sent:</B> May 17, 2003 2:02 PM<BR><B>To:</B>
accessd@databaseadvisors.com<BR><B>Subject:</B> Re: [AccessD] SQL
List<BR><BR></FONT></DIV>
<DIV><FONT face=Arial size=2>Well Well. Let me confess to what I have
done THIS time. Years ago I started out as a contract Access programmer
and had never touched Access. Now I went and got myself hired at this
great company as Database Administrator for SQL and a Crystal
Programmer. Oh my. I started Friday; they interviewed me Tuesday
afternoon and called me Thursday afternoon to start. They know I am not
that proficient in SQL and Crystal, but they seemed more interested in my
personality than my job skills. So there is this SQL program already
written, MasterMind, that I have to write triggers and stored procedures,
creating these for various departments to write reports. I got tired of
consulting after 8 years - too much going on at once and then waiting for
cheap ***'s to pay us. So I walked out and left my poor partner here
WILD EYED as he now has enough work for 1.5 Access programmers and is only one
person. I got an earful when I came home Friday night. My first
project thrown at me was to add a column to a table that increments values by
10, renumerating when the grouping sort changes. Figured that would be
easy - ha ha. I am delving into the cursor crap, did the increment value
in the table itself but it does not know when to start back again at 10.
That is my current dilemma. I am sure that I will catch on, but I am
sure to be a pain in the bum for a month or two until I get my feet under
me. Anybody ever work with MasterMind which I have nicked named
MasterBa*** at this point. Fun fun. All help is appreciated.
And anyone who can calm Mike down with his new found too much work scenario as
well. He smoked two packs of cigarettes my first day on the
job!!!!</FONT></DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=CWortz@tea.state.tx.us href="mailto:CWortz@tea.state.tx.us">Wortz,
Charles</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
title=accessd@databaseadvisors.com
href="mailto:accessd@databaseadvisors.com">accessd@databaseadvisors.com</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Saturday, May 17, 2003 01:03
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> RE: [AccessD] SQL List</DIV>
<DIV><BR></DIV>
<DIV><SPAN class=296105916-17052003><FONT color=#0000ff
size=2>Karen,</FONT></SPAN></DIV>
<DIV><SPAN class=296105916-17052003><FONT color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=296105916-17052003><FONT color=#0000ff size=2>As you see
from the list Dave gives you, there are many flavors of SQL. Which
flavor are you most interested in? M$'s Jet SQL for the Jet db engine, or
M$'s T-SQL for the SQL Server engine, or ANSI SQL that everybody claims
to be compliant with but does not fully implement?</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> dave sharpe
[mailto:davesharpe2@cox.net] <BR><B>Sent:</B> Saturday 2003 May 17
11:29<BR><B>To:</B> accessd@databaseadvisors.com<BR><B>Subject:</B> Re:
[AccessD] SQL List<BR><BR></FONT></DIV>
<DIV><FONT size=2>Karen</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2><A
href="http://groups.yahoo.com/">http://groups.yahoo.com/</A></FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>Has a "SQL_beginners" list</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>Do a search there. They have over 500 SQL related
groups.</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>Dave</FONT></DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=ksfeller@earthlink.net href="mailto:ksfeller@earthlink.net">Karen
Feller Nicholson</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
title=AccessD@databaseadvisors.com
href="mailto:AccessD@databaseadvisors.com">AccessD@databaseadvisors.com</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Saturday, May 17, 2003 8:58
AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> [AccessD] SQL List</DIV>
<DIV><BR></DIV>
<DIV><FONT face=Arial size=2>Does anyone belong to an SQL list similiar to
this Access List that they recommend? </FONT></DIV>
<DIV><FONT face=Arial size=2>Karen S. Nicholson<BR>(724) 942-3437<BR><A
href="mailto:ksfeller@earthlink.net">ksfeller@earthlink.net</A></FONT></DIV></BLOCKQUOTE>
<P>
<HR>
<P></P>_______________________________________________<BR>AccessD mailing
list<BR>AccessD@databaseadvisors.com<BR>http://databaseadvisors.com/mailman/listinfo/accessd<BR>Website:
http://www.databaseadvisors.com<BR></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>