Crystal 10 accessing a SQL2K db.
Hi
I have a quantity field that i would like to perform a sum on, but the data type of the field set in the db is varchar. I'd like to change it to a numeric data type, but am not sure of the best way to do so. Any ideas?
TIA
Matt
Hi
I have a quantity field that i would like to perform a sum on, but the data type of the field set in the db is varchar. I'd like to change it to a numeric data type, but am not sure of the best way to do so. Any ideas?
TIA
Matt