Can anyone help with this little issue Im having? Ineed to make it so you can set a percent value for the progress you think you have accomplished on a project. I added a column to an existing table and set the look up values to be percents from 0 to 100 in 5% incriments.
This worked out well until I realized that in order to be able to have the table let me enter these values they needed to be listed as a data type of "text". Now I have to make a report that performs math on that value and of course I'm getting an error.
Ive tried converting the datatype by appending my query with:
in hopes I could have the query convert it before the math is done. I also tried to have the query perform the conversion just as the math is taking place:
The query just coughs up a bunch of error messages as it tries to calculate the field.
Is there a way to be able to select a % value from a drop down and then later be able to perform math on that value?