Hi,
I have a table with similar data to this:
ID Amount 1 23.23 1 219.23 1 12 2 4491.2 2 23441.33 2 442 2 9823.23
What I would like to do this a assign a new Row Number for each group of ID's, so the results should look as follows:
ID Amount Row 1 23.23 1 1 219.23 2 1 12 3 2 4491.2 1 2 23441.33 2 2 442 3 2 9823.23 4
Is this something like possible in MS Access 2003. I have used the ROW_NUMBER OVER (PARTITION BY XXX ORDER BY XX) in DB2 which seems to do the trick...
Thanks,