New to access: take data from 2 separate tables and combine to single table

See more:

MS-Access

VBA

I have 2 tables. Table 1: Model number and the quantity needed every week for that model

Table 2: The parts needed for the different Models and the usage( number of times that part will be used in that model)

Right now, i need to go about getting the number of parts that I need in total for that week.

Which will be to go look through Table 2 and group them by part number(all the same part numbers are together like row 1-4) and then getting the model name.

From there, using table 1 to get the quantity needed for that model. and repeating the above for the other models that use the same part.


Thank you so much!

What I have tried:

Im new to VBA as well as Access as such I dont really know how to go about doing it. and whether this is possible in Access and if a Query will be much better to do it.

Im looking through a couple of Access vba videos but they dont really seem helpful