Query to find total for all unpaid orders

[SequelChik]

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="Red"
WHERE Paid="No"
AND OrderDate=Now()>30

but it doesnt work. Can anyone help me?
Thanx x

 

[danvlas]

WHERE (Paid=&quot;No&quot AND (OrderDate <= Now()- 30)

or

WHERE (Paid=&quot;No&quot AND (OrderDate <= Date()- 30)

or

WHERE Paid=&quot;No&quot; AND DateDiff(&quot;d&quot;, OrderDate, Date())>= 30

Good luck




Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[SequelChik]

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