Sequence Number

  • Thread starter Thread starter Daniel
  • Start date Start date
D

Daniel

Does anybody know of a way I can create a sequence number
in a column based on an idcode in another coumn and
reverts to 1 everytime it comes across a new ID code for
instance
xxxxx 1
xxxxx 2
xxxxx 3
xxxxx 4
zzzzz 1
zzzzz 2
ccccc 1
ccccc 2
ccccc 3

Can anbody help?
 
Hi,


Since the records, as data, can move in the table, you need to have a
field that differentiate uniquely the order. As example, if you have (code,
dateTime) as fields, then


SELECT a.code, COUNT(*) As Rank
FROM myTable As a INNER JOIN myTable As b
ON a.code=b.code AND a.dateTime>=b.dateTime
GROUP BY a.code



could do.


Hoping it may help,
Vanderghast, Access MVP
 
Back
Top