I would like not show any blank lines in my report if there is some data in my query that returns empty. how can this be done?
put a <>"" in your query is one way.
if you fail to plan, you plan to fail
Forum Rules