I need help with a Running Count Query.
Lets say i have one column,

X
X
X
T
T
E
E
E
E
E

i want to make a query that adds a running count column, like the one below

X ,1
X ,2
X ,3


T ,1
T ,2
E ,1
E ,2
E ,3
E ,4
E ,5

Does anyone know how to do this? any help is GREATLY appreciated.