Help with inventory stock level

[Al]

How can I make an inventory stock level on a form that shows the percentage
of what is left in the stock by a bar (say a colored box with the color goes
up or down based on the quantity on hand vs quantity sold. can some one help.
thanks
Al

 

[Dale Fye]

Al,

It depends on what other data is going to be available on the form. I would
need a little more information to give you a specific set of code. If, for
example, you select an inventory item, and it opens this form based on a
query that contains the number of the selected item in stock, and the number
sold during the previous week, you could add a box to the form, and in the
OnCurrent event, you could compute the height of the bar based on the ratio
of these values, then set the top property equal to some constant (where you
want the bottom of the bar to appear on the form) minus the height. You
could even change the background color of the bar depending on the ratio of
the two numbers.

HTH
Dale

 

[Al]

Thank you Dale for responding,
here is the info:
data from Qry base on table

Fields
Item
PM_Quantity_Received
PM_Quantity_Dispatched
PM_QuantityOnHand
The PM_QuantityOnHand would be the result of The total number of
PM_Quantity_Received Per Item less the Total number of PM_Quantity_Dispatched
per the same item.
I tried to represent this by 2 text boxes where the inside text box1there is
text box2(colored differently) will have its top property set based on that
ratio you were talking about. I was never able to get it box2 move right, It
always moved downward instead of upward from the base of box1. I guess the
whole approach I took was wrong. I hope that I gave you enough info. what I
am trying to do is as soon as the item 's selected the bar will show how much
in stock. I wanted to show grading scale on the left (0,20,40,60,80,100) with
the colored box moving up or down to show the quantity left in stock. I hope
that you can help me with this. thanks
Al