You have chosen to sponsor your bid up to a maximum amount of .
I have two different sheets in Excel- Chassis numbers incoming, datewise; and chassis numbers outgoing, datewise. I want these sheets to go in two different tables in a Microsoft access database. Then, a third table that has both of these tables' data.
The reports would be:
Closing stock for a particular date (Chassis IN but not OUT)
Sold Stock for the date (Chassis IN and OUT)
Unmatched OUTs (Chassis OUT but not IN)