Search results

Hi Assuming I have a table with 100++ fields whereby some of the columns have 0 values. For this, how do I write a sql query in access to display only columns which do not have 0 values. In other words, I need to hide those columns which have 0 values. Thanks Regards Syima