Try: If (month(date) = 4 and Year(date) = 2008; value ; 0 )
Dave Parry wrote:
I'm trying to add invoice values for individual months.
is there some way round this or a better way of doing this.
Yes, of course there is a better way: the way you're going you'd need a calculation field for every possible month.
Define a calculation field cMonth (result is Date) =
Date - Day ( Date ) + 1
Then produce a summary report sub-summarized by cMonth.