I have two tables i want to select some specific numbers of records from table 1. the count of records must be equal to value mention in table 2.

Table1  

![Table 1](https://i.stack.imgur.com/pGzYV.png)

Table2  

![Table 2](https://i.stack.imgur.com/KmbcV.png)

Number of records in output must be equal to qty column in table 2. is it possible using access or i have to use VBA.