Omiting empty cells in a query to show on Report

[Brian62]

I am trying to create a query that will remove empty cells in all columns off of another query that collects the data from multiple tables. I like to combine the cells with data in a report.

Example:

Name Date Column1 Column2 Column3 etc
Sally 10/01/10 Text no text text .....
Ted 10/02/10 no Text Text No text

I like it to show something like this on a report:

Name Date
Sally 10/01/10 Text Text Text
Ted 10/02/10 Text Text Text


Is there a way I can do this?

[HiTechCoach]

Maybe this will help:

Return a concatenated list of sub-record values