D
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.
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.