|
||||||
|
Next Appointment By Richard Rost 2 years ago Calculate Next Recurring Appointment Date 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. MembersMembers 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.
Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the files from class plus get access to the Code Vault. If you're not a member, Join Today!
Links
Suggested Course
Keywordsmicrosoft 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, Due Dates, Due Date, DueDates, DueDate
|
||||||||||||||||||||||||
| |||
Keywords: TechHelp Access appointment scheduling system, appointment due date, recurring appointment, schedule, meeting, bookings, dateadd, date add, vba, afterupdate, after update, Due Dates, Due Date, DueDates, DueDate PermaLink Next Appointment in Microsoft Access |