Hi Muhammad,

This can be completed quite easily by creating a calculated field that uses the IIF() function to translate these string answers to integer values. I've provided an example in the attached workbook.

For more information regarding calculated fields I would review the Calculation tutorials here.

Not a problem Muhammad - I am still quite new to these forums so I hope I am doing this appropriately. I Believe you should be able to see the attachment beneath my reply when you view the full discussion.