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!

Recent content by SequelChik

  1. SequelChik

    Archive Unordered Products

    Thanks a lot for your help, I am new to this and its so complicated! SequelChik x
  2. SequelChik

    Select Statement

    sorry mate, I'm only new to this
  3. SequelChik

    Select Statement

    ermm... try NOT statusB="V" instead of AND x
  4. SequelChik

    Select Statement

    hi, i think you should try; Select Username From (TableName) WHERE Status="O" AND StatusB NOT "V" Hope it helps
  5. 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))...
  6. SequelChik

    Query to find total for all unpaid orders

    Thanks for your help, I'll give them a try, although I think I might be going wrong at the beginning of the statement SequelChik x
  7. 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
See more

Part and Inventory Search

Back
Top