Hi,
I have set up a inventory management database which has a control to calculate stock on hand. The control is working fine but when I try to show the value of this control in a report I get the #Error message.
I have tried many different options in the control source of the report: Forms!frm_products!Text21, frm_products!Forms!text21, Forms!subfrm_inventorymovement!=sum([Stock Received]-[Stock Issued]-[Shrinckage])
I also tried using a query and linking the control to the query, but the query then calculates the totals of Units Received etc etc and not for each individual product so thats not going to help with the stock report.
The purpose of my stock report is to be able to compare current stock an hand levels with the reorder levels.
Thanks in advance for your help.
Kerry.
I have set up a inventory management database which has a control to calculate stock on hand. The control is working fine but when I try to show the value of this control in a report I get the #Error message.
I have tried many different options in the control source of the report: Forms!frm_products!Text21, frm_products!Forms!text21, Forms!subfrm_inventorymovement!=sum([Stock Received]-[Stock Issued]-[Shrinckage])
I also tried using a query and linking the control to the query, but the query then calculates the totals of Units Received etc etc and not for each individual product so thats not going to help with the stock report.
The purpose of my stock report is to be able to compare current stock an hand levels with the reorder levels.
Thanks in advance for your help.
Kerry.
