support or compact items

[Pamela Creighton]

Okay I know this is strange and maybe I am missing something simple
I have 3 table that I wish to combine into a simple query to export out to
excell
Table 1 has idfield, name, address one to many table
Fred anytown
Sam anytown
Table 2 is idfield, item desc, this is a many item same id field number
Fred apples
Fred grapes
Sam apple
Sam orange
Table 3 is idfield, item desc, this is a many item same idfield number
Fred red
Fred blue
Fred purple
Sam green
Sam blue

If I create a query or append to temp table I get the following
Fred anytown apple {blank}
Fred anytown grape {blank}
Fred anytown {blank} red
Fred anytown {blank} blue
Fred anytown {blank} purple

What I am trying to get is a compacted list that does not create blanks or
a way to supress the blanks
Table 1 info Table 2 info Table 3 info
Fred anytown apple red
Fred anytown grape blue
Fred anytown {blank} purple

Any help suggestions greatly appreciated