Friends,
I’m creating a database, the object of which is to produce a Directory of the members of my high school class. Some, but not many, have two home addresses (ex. A snowbird with a Florida home and an NC mountain home). Where there is a second home, I’d like it to appear in the report.
I’m at the design the report stage and much blank space is consumed where the classmate has no second home. I’d like to "tighten" the vertical layout by recovering the space for those entries where there is no second home. (And this is 95% of the Class.)
How can I remove the labels for Home2? It has occurred to me that I could use an “if null” (or iif null) in the criteria fields of the query underlying the Report might work. However, I doubt that would element the labels (although it might).
I’ve also considered the Label properties as a method for exclusion. (But doubt this is the solution.) Or is a "Second Home" sub-report the answer?
PLUS, I don’t know how to construct the statement for the criteria fields.
Has anyone suggestions? As ever, thank you in advance for all your help!
DL