Good Day guys.
I have created a small database with the following tables.
-Sales which includes item number, qty sold, price and invoice date,
-Purchases which has purchase date, part number, qty purchased and price.
I want to generate a weekly report of the inventory what will tell me what was sold from Monday to Friday.
my brain is tuck now any help will be appreciated.