Hi all, looking for a method to number a table sequentially, but the sequence only increments if the value in a certain column is different. as in
seq | parish ------------------------ 1 | Kingston 1 | Kingston 1 | Kingston 1 | Kingston 2 | Lucea 3 | Morant Bay 3 | Morant Bay 3 | Morant Bay 4 | Port Antonio 5 | Savannah-La-Mar 5 | Savannah-La-Mar 5 | Savannah-La-Mar so i guess i would order by a certain column and then the 'magic sequence' would be a column that only increments when the column changes. Rhys ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
