Using Access2000, i need help coding the SEQ field (see sample below)
TIA,
Bob

trans_id beg_date end_date seq
149 1/1/2003 12/31/2003 1
2331 1/1/2003 2/22/2003 1
2331 2/23/2003 6/28/2003 2
2331 6/29/2003 9/6/2003 3
2331 9/7/2003 12/31/2003 4
7789 1/1/2003 8/5/2003 1
7789 8/6/2003 12/31/2003 2
10003 1/1/2003 12/31/2003 1
etc...

Make a query that does a Group on the Trans_Id and count of Trans_id. Then
open the query as a recordset, and loop through the recordset doing a find
by the trans_id and incrementing the SEQ (since you know the number of
records for each trans_id).
Art

"BFord" <nospam (AT) nospam (DOT) com> wrote