Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: SequelChik
  • Content: Threads
  • Order by date
  1. SequelChik

    Archive Unordered Products

    Hi, can anyone help me, my boss has asked me to archive all products that have not been ordered for the past 6 months. I'm new to this but I know it is a Make-Table query, so I tried; Select ProductID, OrderDate From Product, Order (Inner Join,etc.......) WHERE (((Order.OrderDate)<Date()-180))...
  2. SequelChik

    Query to find total for all unpaid orders

    I can't get this right, I need to find an update query that will update the status of all unpaid orders of over 1 month to 'red'. I've tried UPDATE Customer SET Customer.Status=&quot;Red&quot; WHERE Paid=&quot;No&quot; AND OrderDate=Now()>30 but it doesnt work. Can anyone help me? Thanx x

Part and Inventory Search

Back
Top