Calculated field to group numbers


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

Advertisements

Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top