Self Formating Report

[Simon21]

Hi,
I am trying to write a report that will self-format based on the output of a query. For example when the field does not have a value or is blank for a particular record then I don’t want the field to show in the report and then the next field with a value is shown in its place, hence no white spaces or gaps on the report. I have attached a word doc that further explains what I am trying to do. Any ideas on what functions to use or how best to tackle this problem would be appreciated.

Many thanks
Simon

 

[viperstingray]

there is always a right way and then there is a sure way:

right way: ?????
sure way: take screen shots, edit them a little and then open those in powerpoint