Report header to reflect grouped Date Range 1

[Geekette]

I'm creating an aging receivables report, using the invoice date as a header. I would like headers like
&quot;+121 Days&quot; for ([inv_date]<Date()-121;
&quot;91 - 120 Days&quot; for ([inv_date] Between Date()-91 And Date()-120 , etc.
Basically, every 30 day interval starts a new group. How do I create headers that reflect that?

 

[ghubbell]

You may try to add code similar to this in the group Header On Format event:
If [inv_date]<Date()-121 Then [aLabelInTheGroupHeader].Caption = &quot;+121 Days&quot;
If [inv_date]..... Then [aLabelInTheGroupHeader].Caption = &quot;WhatEverYouWant&quot;
and so on...
Gord
ghubbell@total.net

 

[Geekette]

thankx a bunch, gord!
your solution is so much more simple than the one i thought of: i created a cross tab query with headings for each of the 30 day intervals. however, it is far too klugy. simplicity is always better!