How to Calculate the Next Recurring Appointment Date for a Regular Customer in Microsoft Access

In this video, I'm going to show you how to automatically calculate a customer's next appointment if they're on a recurring schedule in your Microsoft Access database. Angeline from Manhattan, Kansas (a Gold Member) asks: I own a cleaning service. Some of my clients are weekly, and some are every other week. I store their last appointment date in their customer record. How can I update their next cleaning due date automatically when I change their previous appointment date. Silver Members and up get access to an Extended Cut of this video. Members will learn how to properly calculate exact monthly, quarterly, and annual appointment dates. We will also learn how to store that date in a field in the customer table, instead of just relying on a calculation. This way if the customer cancels or has to reschedule, it's easy to do. MEMBERS VIDEO:    • Next Appointment Date Access - MEMBERS ONL...   BECOME A MEMBER: YouTube:    / @599cd   or My Site: https://599cd.com/THMember LEARN MORE: https://599cd.com/NextAppt LINKS: Calculated Query Fields: https://599cd.com/Calculated Query Criteria: https://599cd.com/Criteria Intro VBA: https://599cd.com/VBA AfterUpdate: https://599cd.com/AfterUpdate DateAdd: https://599cd.com/DateAdd SUGGESTED COURSE: Payables Seminar: https://599cd.com/Payables OTHER COURSES: FREE Access Beginner Level 1: https://599cd.com/Free1 $1 Access Level 2: https://599cd.com/1Dollar FREE TEMPLATE DOWNLOADS: TechHelp Free Templates: https://599cd.com/THFree Blank Template: https://599cd.com/Blank Contact Management: https://599cd.com/Contacts Order Entry & Invoicing: https://599cd.com/Invoicing More Access Templates: https://599cd.com/AccessTemplates ADDITIONAL RESOURCES: Donate to my Tip Jar: https://599cd.com/TipJar Get on my Mailing List: https://599cd.com/YTML Contact Me: https://599cd.com/Contact TechHelp: https://599cd.com/TechHelp Consulting Help: https://599cd.com/DevNet Twitter:   / learningaccess   https://en.wikipedia.org/wiki/Microso... https://products.office.com/en-us/access https://microsoft.com/en-us/microsoft... KEYWORDS: microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, appointment scheduling system, appointment due date, recurring appointment, schedule, meeting, bookings, dateadd, date add, vba, afterupdate, after update QUESTIONS: Please feel free to post your questions or comments below. Thanks.