Nope. There is no easier way than typing True (well you could enter -1 instead of True). Generating the report is going to be VERY, VERY tedious and difficult due to the mal-designed table structure. You would need to build a base query with calculated fields for every one of the 40 courses. Field: Math 101: IIF([Math101]),"Math 101",Null) Field: Math 102: IIF([Math102]), "Math 102"