Reply
Wed 30 Oct, 2013 01:15 pm
i have two tables masterstock and invoiceentry.
In masterstock fields are
medicinename
stocktotal
in invoiceentry table, fields are
medicinename,
stocksold
I want a report combining both tables with medicinename, stocktotal and stocksold along with current status of stock which (stocktotal - stocksold)
@gunasingai,
What format are the tables in? Are we talking access database, SQL, variable arrays, or what?
@DrewDad,
SQL in data envirnoment visual basic