Eliminating null lines in report

[brobb56]

I have created a report from a query. The information in question comes from one table. The data wants to be viewed in this format.



Name Report ID Form 1 Year 1 From 2 Year 2

I want the data be like

Name Report ID Form 1 Year 1
Name (same as above) Report ID (same) Form 2 Year 2

If data is not present in form 2 or year 2 I do not want that line to show. All data present with repeating row info of Name and Report ID once complete then record 2 begins. I need it to look like an Excel spreadsheet. I wonder if an expression will work. I have attached the DB I am working with IVES query and report Can someone help.

[pbaldy]

Please don't post the same question multiple times:

https://www.accessforums.net/forms/o...ine-17512.html