I have a table with data
Col:1 ID
Col.1 1, 2, 3 etc
Col2 Fruit
Col2 Pear, Apple, Orange
Col3 CountofFruit
Col3 2, 4, 7
This would bring back 3 rows with the data above.
I want to increase the row count based on the countofFruit
Therefore, it'll have 2 lines for ID1, 4 for ID2 and 7 for ID3
How can I do this in an access query
Col:1 ID
Col.1 1, 2, 3 etc
Col2 Fruit
Col2 Pear, Apple, Orange
Col3 CountofFruit
Col3 2, 4, 7
This would bring back 3 rows with the data above.
I want to increase the row count based on the countofFruit
Therefore, it'll have 2 lines for ID1, 4 for ID2 and 7 for ID3
How can I do this in an access query