I have a database with two main tables, Clients and Appointments.
I'm being asked to create a report that will list all clients that have not had an appointment within the last 3 months. I'm not really sure how to even begin setting this up.
In the appointment table there if a field for the date of the appointment. Any guidance would be greatly appreciated. Thanks