I have a small stock control database built around a Northwind example. I am trying to build a query that displays items low on stock.
On my products form I have:
Min Order Level field (stored value)
Units on Hand (calculated value from products subform (units received-units sold)).
Q1: Do I use a query to calculate/display this?
Q2: How do I construct an expression to acheive this?
Any help much appreciated
On my products form I have:
Min Order Level field (stored value)
Units on Hand (calculated value from products subform (units received-units sold)).
Q1: Do I use a query to calculate/display this?
Q2: How do I construct an expression to acheive this?
Any help much appreciated