I am attempting to create a report where records are summarized by month, ie, all records created in January 2004 are grouped together followed by a summary beneath the grouped records.

In order to do this, I created a calc field that parses the creation date(auto-enter field) using this formula which returns the value as text...

Year ( date_Created ) & " " & Month ( date_Created )

When I insert the sub-summary part into my layout, I specify to sort based on the calc field discussed above.

My problem is that when I execute the sort, it groups the records by creation date, not by the calc field I created. In other words, its grouping the records based on the field that my calc field uses and not the calc field itself.

Does anyone have an idea of what I may be doing wrong, or, a better means to group by month?

Can you zip and attach a stripped-down sample of your file and identify the troublesome layout/script?

Thanks for responding.

After sleeping on it, I came in to work this morning and got it to work.

I beleive my problem was that I had more than one subsummaries in my report, and when I sorted on multiple fields, more then one of the sorted fields had a subsummary, hence it was misbehaving.

Thanks again.