Dynamic Report Columns RRS feed

  • Question

  • I have a crosstab query with fixed columns, but want one with varying number of columns based on choices the user make in a multi-selectable field (new in Access 2010).  I want the report to use the choices the user made as the column headers, instead of the crosstab query using all possible user choices, resulting in empty columns.  I have 5 columns that will always be used, and 3 other columns where at least one will be used, but could be 2 or 3 of them.  Hope this makes sense.
    Tuesday, December 15, 2015 4:30 PM


  • Hi RobDerosier,

    Could you please tell me in what way did you use to obtain these data?  If you use,  please try to traverse the datatable. If the column is empty, remove the column.

    Best Regards,

    Wednesday, December 16, 2015 2:54 AM