Having one field be one thing, depending on the field of another. (1 Viewer)

[KAllen31]

Hi everyone,

Every month, I will be importing a csv file into Access. This field will be the same, but obviously the info will not.

What I need to do is create a field that will base its value, on another existing field. The end result of this info. will be put into a report for management.

My question is, should I put this into a query, or into the report itself (using an unbound text box, and calculation)?

Here is the info:
I have a string field called probability of closing (looks to the user as a %, (example 10%,30%)
Now, depending on the %, I want this new field to categorize it in a different term.

Example

if it is between 0%-10% then "Discovery"
if it is between 20%-50% Then "General"
if it is between 60%-80% Then "High"
if it is betwwen 90%100% Then "Projected"

I am thinking I would do this using "select case", but I am not sure if I should "code" this into a query, or into the report itself.

Thanks for your time..

[This message has been edited by KAllen31 (edited 10-31-2001).]

[This message has been edited by KAllen31 (edited 10-31-2001).]

 

[Chris RR]

I would code it into a function, using Case, and call that from the query.

 

[KAllen31]

I will give it a shot.

Thanks