Hide colum when all values = 0 without VBA? its possible?

[Aragan]

Hi, i have a query that produces 35 columns(they rappresent different types of sold contracts), i would like to hide the columns that have all the values = 0 wich are always like 25-30 columns... is that possible? i know i can hide them manually but is possible to do it in automatic? maybe in the properties or something?

[Aragan]

For example from:

       2.0A 2.1A 3.0A 
Me       1    1     0
You      1    1     0

to

       2.0A 2.1A 
Me      1    1      
You     1    1

[David04845]

if you make it a cross tab you can put a >0 in the condition.

[Aragan]

but if i make the condition > 0 it will delete all the rows witha > 0 value, for example if the colum is like this

0
0
0
0
0
1

the entire column should be keeped...

[Aragan]

nobody?

[RayMilhon]

Not in a query. Maybe in a report you could use the on format event to sum each of the 35 fields and the onprint event to suppress those fields that the sum = 0 but I don't know of anyother way to do it.

[Aragan]

ok , thx U_U