I am working with a table (that unfortutely I cannot change) that uses "yes/no" boxes for 34 different categories. I want to create a field in a report that shows the text of any categories with "Y" in it. I created a query to get the text: Example: Gifts: IIf([GIFTS_FL]="Y","Gifts","") It is possible for multiple categories to be selected. In a report, I want one field that lists the different categories, separated by a comma. I can do something like this in the query but then I have these "commas" between items that are "N". Is there any easier way to do this? Thanks!