Renumbering data

[chrisk44]

Hello All.

I'm new to QV -and 

I have a problem with renumbering rows in the database... Namely:
The source table looks like this:

ID	DATE
1111	1999-02-15
1111	2008-09-24
2222	2002-06-20
2222	2002-06-20
3333	1996-01-02
3333	2008-07-16
3333	2018-11-30
4444	1998-09-01

Ultimately, for each date change, you should generate a new ID number - new column based old one with ID and one in succession of 1, 2, 3 etc...:

ID	DATE	RENUMBERED_ID
1111	1999-02-15	11111
1111	2008-09-24	11112
2222	2002-06-20	22221
2222	2002-06-20	22221
3333	1996-01-02	33331
3333	2008-07-16	33332
3333	2018-11-30	33333
4444	1998-09-01	44441

Thanks in advance.

[chrisk44]

I'm new to QV -and 

I have a problem with renumbering rows in the database... Namely:
The source table looks like this:

ID	DATE
1111	1999-02-15
1111	2008-09-24
2222	2002-06-20
2222	2002-06-20
3333	1996-01-02
3333	2008-07-16
3333	2018-11-30
4444	1998-09-01

Ultimately, for each date change, you should generate a new ID number - new column based old one with ID and one in succession of 1, 2, 3 etc...:

ID	DATE	RENUMBERED_ID
1111	1999-02-15	11111
1111	2008-09-24	11112
2222	2002-06-20	22221
2222	2002-06-20	22221
3333	1996-01-02	33331
3333	2008-07-16	33332
3333	2018-11-30	33333
4444	1998-09-01	44441

Thanks in advance.

[rwunderlich · Accepted solution]

ID & AutoNumber(DATE, ID) as RENUMBERED_ID

-Rob

[chrisk44]

Thank You - it work like a charm - great!