Date based report

Discussion created by ohannis on Aug 7, 2013
Latest reply on Aug 7, 2013 by mikebeargie

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.