Footnote on a report

[yippie_ky_yay]

Hello Forum,

this problem seems easy in theory - but I can't seem to get it!

The last column is my report is one for misc notes (called "Notes"). It occurs very rarely so I would like to remove it to create more room for my other columns.

What I'd like to do is add an asterix beside one of the field values if the "Notes" field is not null to indicate a footnote (this I've done). Then, when this does happen, populate the unbound textbox in the footer section with the "Notes" field (I've been able to do this directly after the record - just not the page footer).

I'm really not sure how to proceed on this...? Any help would be greatly appreciated!

-Sean

 

[yippie_ky_yay]

Thanks anyways everyone - I have managed to solve it.

For those interested - it turned out to be kinda easy! Whenever "Notes" wasn't null, I assign the value to an empty text box in the footer. Then, on each page header, I assign "" to the textbox (this is so that your footer doesn't appear on each subsequent page.

(warning though - I haven't yet accounted for mult. "Notes" - I'll eventually get it!)

Hope that helps someone!

-Sean