If I have a text field setup in an Access database, and I want Crystal Reports to calculate the sum, based on the text, is that possible?  Currently, I have each of the problem type variables listed separately in the database table, so the report calculates the sum, since a number is entered into that field.   I want to create a text field titled Problem Type, with a drop down box where the variables are listed.  In the report however, I will need to break down each problem type and the sum of those types.