I had the problem that I was trying to do a report by month, but the field that I was keying on had month, day, and year, so I was getting a breakdown by day. To breakdown by month, I introduced an unstored calculated field with a date result, using the formula
Date( Month(CalcDate), 1, Year(CalcDate))
…and keyed off that, instead.
No comments:
Post a Comment