Query, Qty< Reorder level I want "Order Now" to show. syntax?

B

Buzz

Using MS Access 2003, I want to create a query from two fields. When my
quantity on hand field becomes less than my reorder level field, I want
"Order Now to appear. What is the proper way to write this ? I was inputting
the information in expression builder as [Product Table]![Quantity on
Hand]<[Product Table]![Reorder Level] I need the rest of it.
 
D

David F Cox

in design window:

Reorder: iif([Quantity on Hand]<[reorder Level],"Reorder","")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top