I have a report built off a table with multiple yes/no fields. I need to list only those fields with a yes value. For example, there maybe six colors a car comes in, but only three are available. I only want to list those three on the report.
Does anyone know how to do this?
Thanks
Neal

Make a query that selects the records you want and use the query as the recordsource for the report rather than using the table.