Net quantity on hand with both supply and demand

[janschutz]

I have to take existing data from Job Boss data files and create a report
that shows the remaining quantity on hand after each job (supply) is
completed along with each customer order (demand) combined with existing
quantity on hand in inventory.

I guess this is a start. I have been working with Access for many years but
this is something I never tried to create. All the info comes from an
existing data files I just need to create the report through ODBC.

Thanks