Need help finding a way to write a macro with an IF/OR statement.
Have a report that compiles all the data on a single row. So for each
parent, all of their data will be on the same row. At the end of the row, I
have created an IF/OR statement that counts the number of children for each
parent in that row.
I have also created a macro that will allow me to insert additional rows,
based on the number in that column at the end of the row.
Now trying to find a macro that will copy the children's information off
that row to the newly inserted rows below. Not sure if it is possible, since
the number of children vary per parent.
Currently row data looks like:
Name Address City St Child1Name Child1DOB Child2Name Child2DOB # of children
Need for it to now show:
Name Address City St Child1Name Child1DOB
# of children
Child2Name Child2DOB