[solved] – Question 74701

Make a Update Query that will add the phrase “Free Champagne for this Preferred Guest” to the Comments field, but only if the guest stays for days or more.

CHECK-IN DATECHECK-OUT DATE
2/28/20183/28/2018
3/27/20183/31/2018
3/5/20183/17/2018
3/1/20183/3/2018
3/11/20183/15/2018
3/6/20183/14/2018
4/8/20184/19/2018
3/5/20183/10/2018
3/11/20183/17/2018
3/22/20183/24/2018
3/18/20183/24/2018
2/28/20183/3/2018
3/18/20183/24/2018
3/19/20183/30/2018
3/18/20183/23/2018
3/1/2018 3/3/2018
3/4/2018 3/9/2018

Expert Answer

---