I am not sure if i can do the following and how
I have an inventory table and a requisition table. I already have a report that displays the difference betwen the quantity in the inventory and the requisitioned quantity.
All i want to do is to check if the left over quantity is below a certain point called the threshold. If it is below the threshold it should be displayed in a report otherwise it should not be.
i have the threshold quantity set when i enter the data into the inventory in the first place.
my SQL query does not seem to be working
please let me know
I have an inventory table and a requisition table. I already have a report that displays the difference betwen the quantity in the inventory and the requisitioned quantity.
All i want to do is to check if the left over quantity is below a certain point called the threshold. If it is below the threshold it should be displayed in a report otherwise it should not be.
i have the threshold quantity set when i enter the data into the inventory in the first place.
my SQL query does not seem to be working
please let me know