Eliminate blank lines in report 1

[TonyG57]

Each record in my database can contain name details of up to 4 individuals. A report listing Surname, Forename and Title of all the people in the database has blank lines when only the the first one, two or three sets of personal details have been used in a record.
Is there a way to produce such a report eliminating the blank lines perhaps using such functions as 'if' or 'isblank to pass over the unwanted fields without attempting to print them?

 

[paulbent]

No, your database design prevents this. You can't set a field on a report to print for some records and not for others.

In "database speak" your data isn't normalised correctly. The 1 to 4 names should be separate records in a joined table. Then you can base a report on this table, grouped by the join field and it will only display the names records related to each main record.

Paul Bent
Northwind IT Systems

http://www.northwindit.co.uk