My table currently has 181 records. 5 of these records have comments. I would like only the comments field from the 5 records with data to display in the page footer section, on the corresponding page containing the record.
I currently have the field placed in the page footer area, but it will only display the comments of the last record on the page. So if the field's value is null, nothing displays - if there is data in the field & it is the last record on the page, it will display.
Thanks for helping a Newbie. nls
I currently have the field placed in the page footer area, but it will only display the comments of the last record on the page. So if the field's value is null, nothing displays - if there is data in the field & it is the last record on the page, it will display.
Thanks for helping a Newbie. nls