How is your [Goals] table set up? Do you have one goal record per month? One per year? I’ve got some ideas on how to do what you want, but knowing how goals and clients are linked (figuratively and literally) is important.
I have one goal record per month.
In Goals, first column is month, second colum is the goal, and I would like the number of new clients in the third.
The other table is Contacts where I have dates, clients and non clients. I would like to count the number of new clients per month. Hope that helps !