Prev: totals query - group by email max of date
Next: List Box - User Edit
From: Laura1 via AccessMonster.com on 12 Apr 2010 23:20
Thank you very much!!!! Figured it out!!!!

Tom Wickerath wrote:
>Hi Laura,
>
>> Thanks this is really over my head...sorry...
>
>Paul gave you a SQL (Structured Query Language) statement, ie. a query. To
>make use of what he gave you, create a new query. Dismiss the Add Table
>dialog, without adding any tables. Then change to SQL View. You should see
>the SQL keyword SELECT highlighted. Backspace over this to remove it. Then
>copy the SQL statement that Paul gave you, and paste it into the SQL View.
>
>Notes:
>1.) Use square brackets for any field names that include spaces, special
>characters, or reserved words.
>
>2.) Substitute "YourTable" in the SQL statement with the actual name of your
>table. Use square brackets if your table name includes spaces, special
>characters or is a reserved word.
>
>SELECT A.AssociateID, A.[Deal ID], A.[Associate Role],
>1 + count(B.[Deal ID]) AS [Sequence Number]
>
>FROM YourTable AS A
>
>LEFT JOIN YourTable AS B
>ON (B.[Deal ID]=A.[Deal ID])
>AND (B.[Associate Role]=A.[Associate Role])
>AND (B.AssociateID < A.AssociateID)
>
>GROUP BY A.[Deal ID], A.[Associate Role], A.AssociateID;
>
>I just created a quickie sample based on Paul's SQL statement, and it works
>just fine. If you need, I can post a zipped copy and provide a download link
>to you.
>
>Tom Wickerath
>Microsoft Access MVP
>http://www.accessmvp.com/TWickerath/
>__________________________________________
>
>> Thanks this is really over my head...sorry...
>>
>[quoted text clipped - 34 lines]
>> >This arbitrarily assumes you want the sequence ordered by the associateID
>> >number.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access/201004/1

First  |  Prev  | 
Pages: 1 2
Prev: totals query - group by email max of date
Next: List Box - User Edit