Ignore blank rows in a UNION ALL query

[Access_Novice]

I had to use a UNION ALL on an Inner, Left and Right outer join to create a FULL outer join. But I noticed that in my results there are many blank rows. Since I did UNION ALL to the underlying SQL code, I can't see the design grid. There is only Datasheet and SQL view.

So I would have to modify my SQL code. Which of the 3 queries would I modify? What part of the query would I modify?

Additionally, to help me understand this more, what is the origin of these blank rows?

[alansidman]

How about creating a select query using the UNION ALL query as the record source and set the criteria to NOT Null for those fields you want to include in the results.