Complex If Statement

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi everyone! I have two tables concerned, one 'tblProducts' the other
'tblOrders'. I have two fields in 'tblProducts' - (QuantityOrdered) and
(ItemsInStock). When the number of (ItemsInStock) falls below 25% of the
number (Quantity Ordered) Then insert record into 'tblOrders'.
Thanks
 

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

If Statement - Complex 4
Order entry 5
Sales & Purchase 1
dlookup 2
query doesn't work at all 1
Copy selected records from two tables to two new tables 2
Order Details Table - Auto Number field ?? 4
Average of a Date Field 2

Back
Top