So I have a simple database set up for customer service contracts. These contracts need to be reviewed yearly. I need to create a report that shows us all of our past due contracts. However, these reports need to be sorted by:
1: 0-30 days past due
2: 30-60 days past due
3: 60-90 days past due
4: 90+ days past due
I was able to calculate the days over due just fine, This just tells me how many days from the current day another day is.
But I have no idea on how to group them, the way I need them. Any help would be great. I'm fairly new to the reporting part of access btw.
1: 0-30 days past due
2: 30-60 days past due
3: 60-90 days past due
4: 90+ days past due
I was able to calculate the days over due just fine, This just tells me how many days from the current day another day is.
Code:
DateDiff("d",[Products]![Initial Date],Now())-365But I have no idea on how to group them, the way I need them. Any help would be great. I'm fairly new to the reporting part of access btw.
