Search results

What would I use for a formuls to find all product that are in stock. like I have a price for all products that i stock, but some i don't have in stock. How would I query for the ones that I have in stock? In my table I have it as UnitsOnHand, I have it as how many, like 1 or 3 or 4 etc. And...

I am trying to do a simple querry I am trying to do a querry were I have the product #, product, amount in stock, and the price. All i want to do is get the total amount. I am useing this for a calculation. amount on hand * price. I have this in a new field, the problem is that when I run it, it...