Hide Null field Line

[brobb56]

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

Borrower Report ID Form 1 Year 1 Form 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. It seems like I can do an expression but i am lost Can someone help.

[pbaldy]

Please don't post the same question multiple times:

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