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.