Need help with SQL Update Statement

[BettyN]

One of our users has requested that we create a job that will automatically close the RMA (return material authorization) lines and RMA header if certain criteria is met.

I have attached a document outlining the criteria. I have been working on a select statement first to make sure the records returned are meeting the criteria and I don't know how to make one of the criteria work, which is for the credit check.

I also attached my select query if needed. How to I add the code for the credit check?

Thanks for the help.
Betty

[Wendell]

It depends on what kind of field type RMADetail.iscustomercredit is. If it is a Boolean field, you can use True, if it is a numeric field, you could say Not Null. But we need to know more about where the query is being run - is it in SQL Server or is it in Access - to be really helpful. Also the version of what you are using, ie SQL Server 2012, or Access 2010.

[BettyN]

I am using SQL 2014. The RMADetail.IsCustomerCredit field is a bit field.

Thanks.
Betty

[HansV]

Does it do what you want if you add

AND (RMADetail.IsCustomerCredit = 0 OR RMADetail.AWBToReceive = 'EV' OR RMADetail.AWBToReceive IS NULL)

[BettyN]

I will give this a try, HansV. I'll let you know.

Thanks.
Betty

[BettyN]

Hans,

I had to make one change but it appears to be working. Thank you for the help.
Betty