Calc How Many Times K9s Fed

[Totes]

Hello everyone, been a while since I had to ask a question, but I now have one.

We are working on a layout showing the feeding days of our K9s.

Here is what I have tried without any luck as it returns a count for every feeding entry not just the one for this month and this year:

If( Date_Of_Feeding =( Get (CurrentDate ) );

Get ( FoundCount ))

What I am trying to do is get a total for each month for the current year.

DB Screenshot

Can you point me in the right direction.

Thanks again,

Jim

Edited June 7, 2009 by Guest