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).]
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).]