Community archive

Ask something
Discussion Locked

Access97 Reports

0 helpful
2 replies

by sholmes

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I am trying to setup an access report based on a customer comment database. I want the report to show the date of the comment and the comment according to department. There are several departments but they do not always have a comment for them. If iam doing a report on say the reservations department, how do i get the report to leave out any blank comment areas and only show comments that have been filled in. Thank you for any help.

2 replies

by sbp

One way of doing this is by creating a 'query' first and under the COMMENT field, add the criteria NOT NULL - Access will include the correct syntax (which is Is Not Null)

This eliminates the blank comments.

You would then create a new REPORT using the Query you just created.

by shanghai sam

I am having the same problem except i am using a subReport. If the record on the Report has no subReports, I am keft with a large white space in between records. I think you can put an IF statement so that when the values in the subReport are Nullset its visible property to false, in your case the visible property of the text box. The only thing i am unsure of is where to place this code??? If you have any ideas let me know. Thanks.

This discussion is closed to new replies.