counting related records by date
I have two related tables: Client and Appointments, related by the field ClientID. In the appointment table, each client will have multiple appointments over several months. I need to count the number of remaining appointments after the current date, so that when I run an appointment list for today, I can see the number of apointments after today. How to do this?