Printing a list without blank spaces

[thesaurusrex]

I have an inspection checklist with drop down selection boxes, each of which has an incorrect response. If the response is incorrect, the field is highlighted and the user inputs an explanation in a memo field. I need to be able to either print out a list of all the problems and their explanations or export such a list into Excel for further tracking (I have a select query so that the report is based on only one record). However, I can't figure out how to get rid of blank fields and not end up with pages of blank spaces. I have two ways of choosing which fields should be listed: all the ones which are not null, or whose corresponding drop down value is 1. Anyone have some suggestions for implementing this?

 

[thesaurusrex]

Just had a thought.....would it be possible to create a make table query which created a record for each problem? That way I could print out a report of each record (one problem) linked to a particular inspection and not have to worry about spacing at all....just filter the records to a particular inspection. That'd also enable me to add capabilities for tracking progress on each particular problem. Does this sound like it would work, and do you have any advice on how to create a variable number of records for each inspection?

Edit: Or perhaps adding an append record query to the on update property of each comment? And if I defined the primary key as two columns - the inspection ID number and the name of the comment field - would I get errors stating that the record already exists, or would it simply overwrite the old one (which is what I would want)?

Thanks for any help.

 

[thesaurusrex]

I'm sorry, I didn't explain that very well. Each record can have up to 100 comments, each corresponding to a different question....there will only be comments corresponding to questions whose value is 1 ("incorrect" responses). However, most records only have a dozen comments or so. I am only printing one record at a time, but I wish to have only the comments print which actually have text in them. I'd also like them to be labeled, otherwise the comments would not make sense. The only solution I've been able to come up with thusfar would be changing the comments into a many-to-many relationship with the records, but I'm hoping it doesn't come to that.