I want to display the Key and Text for 0CALYEAR in a report. I searched the forum and it seems that for doing this I need to create a text variable. In the query designer I tried creating a text variable for 0CALYEAR, but in the variable wizard, the "Type of characteristic" drop-down is greyed out. Please guide me in creating a text variable and on a larger scale in getting the Key and Text for 0CALYEAR. Thanks!