>
>What is happening now is the header is shifting between header1 and header2
>and ends up (i guess) with the value on the last line.
>
>What I need is a way to say if there are any values in this column take header1
>otherwise take header2. How can I do this with the limitation
>that I can only use functions.
>
>I could of course make a program but I am trying to avoid this.
>I don't want to use seek() becuase then I need an index on each column..
>
>I hope this makes sense...
>
>Thanx!

I wonder if you might be better off using variables for your header which you set prior to running your report. Actually, I believe this is a simpler approach.