I wouldn't be surprised if this were a simple matter that I'm just overlooking, but I've tried everything I can think of and haven't yet been successful.
I want to create statements, with outstanding invoices summed by date (0-30 days old, 31-60, 61-90, over 90). I've created the query with the DaysOpen calculated field, but when I try to create a crosstab query with the info, I get each individual elapsed time as its own column heading rather than the grouping I want. I found an example to group the days by month, but that isn't much help to me.
Can anyone lend a hand?