ok so i've been going over this query for days now, trying to figure out how to get this to work. basically the query needs to measure ingredients currently in vats and then measure the vat levels against the amount of ingredients required to produce a product, if there is enough of the ingredients in the vats the sstem should display "OK", if there isn't the system should display "Refill". below is the expression i've been trying to use. any help would be a great help :)

IIf([Vat level]>"or"=[Total Ingredients Required (ml)],"OK")

If you mean what I think you mean, try

IIf([Vat level]>=[Total Ingredients Required (ml)],"OK")

LOL, thanx very much. its always something sooo... simple

No problemo, and welcome to the site by the way.

TY happy to be here :)