display results in report
i am trying to use th result of a query in another and display the results in the report.
i have a check stock report that uses a query that subtracts the inventory input and the requisitioned quantity.
in this report i want to be able to use that result and compare it with the threshold quantity set by me in the inventory table. if this is below the threshold quantity then it must be displayed on the report
can anyone help me with this
thanks