Grouping by Date Ranges

[Graham T]

I have a query that uses the DateDiff function to calculate the number of days taken to make payment:

DaysToPay: DateDiff("d",[dtmTransactionDate],[dtmPaymentDate]).

What I would now like to do is create a report grouping payment times. The groups that are required are as follows:

Upto 14 days,
15 to 20 days,
21 to 60 days,
60 + days.

Is it possible to create these groups directly on the report using an expression or would the grouping need to be applied in the query.

Thanks in advance

Graham

 

[Graham T]

Pat

I thought that maybe the answer.

Would the case be that I would need to create a new field for each expression all in one query, and then flag them up somehow for the report to group them?

Graham