suppress columns if no data

[AnneMarie]

I have several tabular reports based on different manufacturing plants. Some
plants will have data in a column while others will not. By following your
different threads, I have learned how not print the label..

IIf([AsphaltTons] Is Null,Null,"AsphaltTons")

but I was wondering if it was possible to shift the columns that are to the
right of the null columns over to fill the now blank spaces.

 

[Duane Hookom]

It is sufficiently convulted to move columns leftward that I would consider
normalizing your table structure so that "AsphaltTons" became a data value
rather than a field name. I would however, be off on this assumption if
AsphaltTons was the result of a crosstab or there is something unique about
your application.