AnsweredAssumed Answered

counting related records by date

Question asked by DennisPrickett on Dec 7, 2011
Latest reply on Dec 7, 2011 by philmodjunk


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?