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

Similar Threads

Extracting Specific Data for query 1
Minimum Reorder 1
Update query to update new qty and cost 1
combining a hyperlink and table data to form complete link HELP!!! 1
deduct order quantity from credit limit 1
query to show where no data in a stated column 0
Condition and equation problems 4
2 different Qty in order details in northwind 5

Top