I have created a report that uses a query based on successively linked tables. It follows the procedure described in another forum (paid) under the topic "How do I set up outline numbering in an MS Access Report." It works well to generate the outline for me, but the difference is that not all of my Steps have children steps associated with them.
I am aiming for this:
But am ending up with blank rows where a Step does not have any 'children' steps.
I figure I'm going to have to add an equation, like "iif([thisthingisblank] then [skip it])" but i'm not sure what sort of script to use. I don't know how to tell Access to "skip this row." Is this even possible?
Any advice?
Thanks much!
Susan Cannon