Multiple columns in report

[dbaJSmith]

Hello all:
Using Access 2003, having trouble with a 2 column report. The column setup itself works fine, no issues there. The problem now exists in the page header that I created. I duplicated my headers so that they are labeled correctly; when I only have 1 column of data, however, I'd like the second set of headers to be supressed or hidden. Is that an option using Access? If so, how do I go about setting it up? Is it a Section setting to duplicate headers on the columns, or a field setting that suppresses the field when no data exists in the second column set? Thanks!

 

[lameid]

My advice, don't put the headers in the page header. Instead add some sort of grouping (even if you add a literal 1 to your query and group by that) and put your headers in the group header. Finally, set the section to repeat.

You probably could fix it using some convulated VBA solution, but the one thing I am sure of is my solution will be easier.