Report grouping and labels

[Paradigm]

I have a report for overdue invoices grouped by day with a 30 day interval.
I want to label the groups e.g. Less than 30 day, 30 days, 60 day, etc.
How can I label the group in this way?
Alec

 

[Duane Hookom]

I would create a table of day intervals:
tblDayIntervals
===================
MinDays MaxDays IntervalTitle
0 30 Less than 30
31 60 30 to 60 days
61 90 60 to 90 days
91 99999 over 90 days

You can add this table to your report's record source and set the criteria
under your [Days Overdue] field to:
Betwee [MinDays] And [MaxDays]
Add the MinDays and IntervalTitle fields to your report's record source so
that you can sort by MinDays and display the IntervalTitle in your group
header.

 

[Paradigm]

Thanks for helping. I am having a little difficulty understanding. Do I
create a table with the min/max days in it and then add this to the report
record source? And then how do I link this to the daysoverdue field?
Alec

I would create a table of day intervals:
tblDayIntervals
===================
MinDays MaxDays IntervalTitle
0 30 Less than 30
31 60 30 to 60 days
61 90 60 to 90 days
91 99999 over 90 days

You can add this table to your report's record source and set the criteria
under your [Days Overdue] field to:
Betwee [MinDays] And [MaxDays]
Add the MinDays and IntervalTitle fields to your report's record source so
that you can sort by MinDays and display the IntervalTitle in your group
header.


--
Duane Hookom
MS Access MVP
--

I have a report for overdue invoices grouped by day with a 30 day interval.
I want to label the groups e.g. Less than 30 day, 30 days, 60 day, etc.
How can I label the group in this way?
Alec

 

[Duane Hookom]

Yes, create the table I suggested.

"how do I link this" re-read my response starting at "You can add this
table..."

--
Duane Hookom
MS Access MVP
--

Thanks for helping. I am having a little difficulty understanding. Do I
create a table with the min/max days in it and then add this to the report
record source? And then how do I link this to the daysoverdue field?
Alec

I would create a table of day intervals:
tblDayIntervals
===================
MinDays MaxDays IntervalTitle
0 30 Less than 30
31 60 30 to 60 days
61 90 60 to 90 days
91 99999 over 90 days

You can add this table to your report's record source and set the
criteria
under your [Days Overdue] field to:
Betwee [MinDays] And [MaxDays]
Add the MinDays and IntervalTitle fields to your report's record source
so
that you can sort by MinDays and display the IntervalTitle in your group
header.


--
Duane Hookom
MS Access MVP
--

I have a report for overdue invoices grouped by day with a 30 day interval.
I want to label the groups e.g. Less than 30 day, 30 days, 60 day, etc.
How can I label the group in this way?
Alec