Omiting null line

[brobb56]

I have created a report in which I have name TIN Form Year
There is year/form 1 year/form 2 year/Form 3 and Year/form 4.


My problem is name and TIN show for years2 3 and 4 when there is no data is year and form. I want the report to omit the line there is no data present in year and form. Can you help

[pbaldy]

As previously discussed, your denormalized data is going to make this harder than it should be. I thought I gave you one method, though I now recall you wanted to repeat the name and TIN. The easiest way I can think of to do that is normalize the data with a UNION query:

SELECT Name, TIN, Form1, Year1
FROM TableName
WHERE Form1 Is Not Null
UNION ALL
SELECT Name, TIN, Form2, Year2
FROM TableName
WHERE Form2 Is Not Null
UNION ALL
...

and base your report on that.

[brobb56]

Not sure how you do that. I am sorry I am new to this. Here is the db.

[pbaldy]

Give it a try at least. Start a query using the first year and then switch to SQL view and add the others (you can't build a UNION query in the designer).

[brobb56]

Still unsure how to to this. I am sorry I am trying to learn. Here is the db. My Ives report is what is in question taken from Ives query.