suppress columns if no data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
Back
Top