Creating new values in a table based on existing values

[Dave Edwards]

I've got a table tblTopValues containing two fields, a unique ID number and a value. I want to be able to create a new table (or put values into an empty one), with the second field sequentially numbered from 1 to the value already held e.g.

ID Number
3 5
2 2
4 3

ID Number
3 1
3 2
3 3
3 4
3 5
2 1
2 2
4 1
4 2
4 3

I assume that I will have to do this in code by looping through the table, as opposed to a query. Can anyone offer any help please.

Dave

 

[Dave Edwards]

I have now been sent an example of this, thanks.