I have multiple records in my database, of which different fields for each record are null. I want the report to show only fields for each record that are populated. For example, fields: a, b, and c for records one and two are 1, 3, null and null, 5, 7, respectively. How do I make the report show fields a and b for record one and fields b and c for record 2?? Any help would be greatly appreciated. Thanks.
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.