Search results

I have a subreport in a report. The subreport consists of 2 controls: 'Report Number' (which is not visible and is a link to the main report) and 'Comments'. Only when 'Comments' has data, I would like it to display in the main report. I'm not familiar with using the HasData or IsNull...

My table has a field called 'Comments'. Very few records in the table have a comment. In the report, most of the record's fields are listed in the Details section. I would like the corresponding comments (for the few records that contain comments) to list in the Section Footer. Only 1 comment...

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

My report is grouped by categories. If a category contains no records, I would like the phase, "No records this quarter" to appear in the Detail of that category. I'm a beginner and was wondering if there is any simple code I can put into the report. Your help appreciated.

My report is quarterly and sometimes does not have data under a grouping. When there is no data, the group does not display. I would like to make the group visible and show the words "No data this quarter" where the data would normally display. Thanks for your help.

In a Report, I would like the word "none" to print when there is no value in the Table. How can I do this? Thanks!