Help with SQL Query

[jo15765]

I have a table named customer and in that table I have several fields. I am wanting to be able to display customers whose bill is over 30 days past due (field name is BillDueDate) and then take those customers and update the field Inactive to Yes.



For the life of me I can't figure out how to set up this query in SQL, can someone please assist!?

I think this will display the bill portion, but to throw in the update I am lost...

Select * from Customer WHERE BillDueDate > 30

[pbaldy]

You'd want to use DateAdd to subtract 30 days from today. Or because it's days you can simply subtract:

(Date() - 30)

Your sign is reversed by the way.

[Aragan]

edit: didnt notice it was solved XD