hi again
i am having a inventory program for sales and purchase entry using vb6 and access.i am storing the opening stock in the database. I want to calculate the closing stock which i do using opening stock + purchase -sale.
Now problem is that i want to show the closing stock in report that should i create a temporary table.or can any one suggest a proper query for it
thank u