AnsweredAssumed Answered

Reporting last activity

Question asked by MattLeach on Apr 24, 2012
Latest reply on Apr 25, 2012 by MattLeach

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

Outcomes