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

G

Guest

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
Qty Query applied to tables listed in another table? 6
combining a hyperlink and table data to form complete link HELP!!! 1
Hard to explain - multiple update fields query... 7
Access Passing the value to a table 1
Order Query 3

Top