Query To Display Qty Purchased & Used

Hello Experts

I need a query that asks a user to input a range of stock codes and a date range

The query results should display the Stock Code, Quantity purchased and Quantity used in a production order

I don't know which tables I need to use to even try

Would someone please help me

Thanks and Regards

Rahul