Search results

Hi Actually the data is imported from MS Excel Spreadsheet and it's not normalised. Dats the main reason why it ends up for 100++ fields. Would appreciate if anyone can help. Thanks

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