Hi
I have a table with ProductID, ProductName, Quantity. I want to display a message in a form (Not a pop up message just a text in the form) If Quantity is 0 any product ""Product ID, ProductName" is Out of stock". If Quantity Less than 5 I want to display ""Product ID,ProductName" is Low Stock". There are many products in the table. I want display the message according to above requirement.
Example: ID001 Paint Brushes Out of stock, ID001 Paint Brushes Low Stock,
I am Not much expert in Access. If someone tells how to this step by step i appreciate it. Looking reply from you guys. Thank You
I have a table with ProductID, ProductName, Quantity. I want to display a message in a form (Not a pop up message just a text in the form) If Quantity is 0 any product ""Product ID, ProductName" is Out of stock". If Quantity Less than 5 I want to display ""Product ID,ProductName" is Low Stock". There are many products in the table. I want display the message according to above requirement.
Example: ID001 Paint Brushes Out of stock, ID001 Paint Brushes Low Stock,
I am Not much expert in Access. If someone tells how to this step by step i appreciate it. Looking reply from you guys. Thank You