Calculated field to group numbers

[Daniel Collison]

I have a dataset that includes a field called Pymnt Days...data in the field
represents the number of days that transpire between date of service and
payment date.

I would like to create a new field -- Pymnt Group -- that groups values in
the Pymnt Days field. For instance, if the value in Pymnt Days is between 0
and 45, then the value in Pymnt Group would be 1; if the value in Pymnt Days
is between 46 and 90, the value in Pymnt Group would be 2; etc., etc.

Is there a formula I might create in an update query that would calculate
the value for Pymnt Group?

Thanks for any assistance.

 

[Duane Hookom]

You might use
Bucket: PymntDays\45 + 1

 

[Daniel Collison]

THANKS! This was very helpful!

You might use
Bucket: PymntDays\45 + 1