How to hide field/column in access sql query

[Syima]

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

 

[Mr. B]

I must tell you that having any table that has that many fields makes me immediately think that your database may not be normalized. I have been doing this for may years and I have had tables that I consided "large" tables but I have never had a table with anywhere close to 100 + fields.

I would first take a look at normalization before continuing.

 

[Galaxiom]

... any table that has that many fields makes me immediately think that your database may not be normalized.

I agree totally.

 

[Syima]

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

 

[Galaxiom]

You would be better off writing queries to normalize the data.

 

[boblarson]

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

There really isn't a way to do what you are wanting to do in the way you are envisioning.