I have a database which has about 60000 rows and 3 columns. Here I have made a picture to show what exactly I want, this picture represent a general view of my data structure and also represent what I want. I have 3 first columns (from left) and I want to create a new column like the last one which named New Text. As you see I want to create a column which duplicate the Text of every row for X times. And X is the frequency of repeated number in Number ID 2. For example: In Number ID 2, 8 repeated four times. So New Text should have four H. (H represent the text) Please consider this to be done by Microsoft Access software, which I have no experience of working with.